Computer Science, asked by goeltanishq492, 3 months ago

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 korockhazra12
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