Excel Formula HELP!!

New Contributor

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.