In a worksheet, cell K12 has a value. A formula is to be entered in cell K15, such
that if the value in cell K12 is more than 300, the value in cell K15 would be 1.33 times the
value of cell K12. Otherwise, the value in cell K15 would be 1.5 times the value in cell K12.
Explain the formula that you use to achieve this.
Answers
Answered by
1
Answer:
In K15 type "=IF(K12>300,K12*1.33,K12*1.5")
Explanation:
Here I am using the if function
The syntax of it is "=IF(statement, if statement is true then, if statement is false then)"
The first part of the formula check whether K12 is greater than 300 or not.
The second part multiples the number in K12 by 1.33 and gets activated if the statement is true.
The third part multiplies the value in K12 by 1.5 and gets activated if the statement is false
Similar questions