Question

The expression =IF(A1 > 9, 7*A1, 10*A1) is used in a spreadsheet.Find the result if A1 is 7

Answer 1

Replacing A1 for 7 on the given expression:

$IF(7>9)$

Since 7 is not greater that 9 we have to use the operation for the false logical value, in this case 10*A1, so:

$10\cdot7=70$

In this case the value for that expression is 70