Description : 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 -Technology
Last Answer : 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.