Forum Discussion
Excel Formula HELP!!
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.
2 Replies
It could be like
=IF(J41>=6.75, "Yes", IF(J41>0, "No", IF(J41=0, 0, "Negative")))
Not quite exact but led me to the correct assembly of the formula. Many thanks.
