Enter a formula in cell F4 using the IF function that returns a value of YES if cell E4 is greater than 2, and a value of NO if

Question

3 years ago

3

not.

1 answer:

bagirrra123 [75] · Answer 1 · 2022-08-15T15:23:19+03:00

Explanation:

The task is very simple. I am explaining you the step by step procedure and also executed sample as an attachment.

Steps:

1. Open Excel

2. Go to E4 cell and enter any number

3. Go to F4 where the if() is expected to be entered

4. Use the formula in F4, =IF(E4>2,"Yes","NO")

5. Cross check the answer by entering different values. Even if it is 2, the result will be "No". Only if the value is >2, "Yes" will appear.

Syntax of IF:

=if(Condition, "True value", "False value")