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.

Related Conversations
Solving Name conflict in excel
stanoh in Excel on
0 Replies
Macro to Import Information from Email Attachments into excel
calof1 in Excel on
0 Replies
i am stuck on vba and copying row based on value
tduff1460 in Excel on
1 Replies
Room Booking using Excel
Maddie1215 in Excel on
0 Replies
How to get to the last line with data in an Excel workbook?
seanp413 in Excel on
2 Replies
Excel Formula Question
BigErn1175 in Excel on
3 Replies