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.
In cell K15, enter the conditional statement as: = IF (K12 > 300, K12 1.33, K12 1.5). Here, IF condition checks the value at K12, that is, if it is greater than 300, then calculate 1.33 of K12, otherwise 1.5 of K12.
