Hey guy its hailey and my favorite song is the start of somethin new
2 answers:
You might be interested in
Answer:
Explanation:
public class Main
{
public static void main(String[] args) {
System.out.println("Test Class:");
Name name = new Name("Dayanand","Ghelaro");
System.out.println("First Name : "+name.getFirstName());
System.out.println("Last Name : "+name.getLastName());
}
}
class Name{
private String firstName; // first name field
private String lastName; // last name field
public Name(String firstName, String lastName){
this.firstName = firstName;
this.lastName = lastName;
}// end of constructor
public String getFirstName(){
return this.firstName;
} // end of method
public String getLastName(){
return this.lastName;
}// end of method
}// end of Name class
Answer:
I have created and attached an image with example values for this question.
First we'll learn the IF function syntax:
IF(logical_test, value_if_true, [value_if_false])
Where
logical_test is the decision making comparison
value_if_true is the result to return when TRUE
value_if_false is the result to return when FALSE
We assume that cells B10 to G10 contain the Total Sales for January to June. And cells B17 to G17 contain the Commissions for January to June.
a.
The formula to use in cell B17 is:
<em>=IF(B10>=200000;True;False)</em>
<em />
b.
The formula to use in cell B17 is:
<em>=IF(B10>=200000;B10*0.35;False)</em>
<em />
c.
The formula to use in cell B17 is:
<em>=IF(B10>=200000;B10*0.35;B10*0.27)</em>
<em />
d.
To copy the formula in B17 to C17:G17, you can just copy and paste or select cell B17 and drag from the black square on the bottom right of the cell.
