Last answered:

19 Nov 2022

Posted on:

18 Nov 2022

0

function returns

image.png
the function..

image.png
if cell is empty the condition is false.
return average of the four cell.





image.png
if cell is has a value the condition is true,
return sum of the four cell.

why it also add the input number supposed to be the answer is 380.

2 answers ( 0 marked as helpful)
Posted on:

18 Nov 2022

0

mine is 380 only

Instructor
Posted on:

19 Nov 2022

0

Hi Jorey!

Thanks for reaching out.

It seems that since you are having no empty cell (ref. the second screenshot), then the third argument of the IF() function is applied (a SUM() operation). That's why Excel returns the sum of all values in cell B9.

Hope this helps.
Kind regards,
Martin

Submit an answer