Jan 10 2019 10:08 AM
Having difficulty in putting the following three conditions and responses into one cell formula:
IF J41 is =>6.75,"YES"
IF J41 is <6.75 AND >0,"NO"
IF J41 is =0,0
Help please.
Jan 10 2019 10:22 AM
It could be like
=IF(J41>=6.75, "Yes", IF(J41>0, "No", IF(J41=0, 0, "Negative")))
Jan 10 2019 11:41 AM
Not quite exact but led me to the correct assembly of the formula. Many thanks.