This checks the cell B2
to verify if it is higher than zero to assign a value of Happy
. If not it checks if it is negative to assign a value of Sad
or Neutral
if B2 is zero.
=IF(B2>0;"Happy";IF(B2<0;"Sad";"Neutral"))
This checks the cell B2
to verify if it is higher than zero to assign a value of Happy
. If not it checks if it is negative to assign a value of Sad
or Neutral
if B2 is zero.
=IF(B2>0;"Happy";IF(B2<0;"Sad";"Neutral"))