Notifications
Clear all
Topic starter
For the two formulas below I need the cell to be blank if the word void is in cell M2 (also if M2 is blank)
=IF(M2="","",IF(M2-J2<=30,1,0))
=M4-J4
Thanks,
Rdawbrey
Posted : 05/04/2017 5:39 pm
Try this
=IF(OR(M2="",M2="void"),"",IF(M2-J2<=30,1,0))
Sunny
Posted : 05/04/2017 9:01 pm
Topic starter
This works =IF(OR(M2="",M2="void"),"",IF(M2-J2<=30,1,0))
What do I do for this one?
=M4-J4
Thanks
Rdawbrey
Posted : 06/04/2017 10:45 am
It's not clear to me what you want to achieve with the =M4-J4? Is it part of the first formula (an extra check or such?).
Or do you want to calculate M4-J4 only if M2-J2<=30?
Or something else?
Posted : 06/04/2017 1:26 pm
Topic starter
For the formula below I need the cell to be blank if the cell is blank or if the word void is in cell M4.
=M4-J4
I figured it out to be this...
=IF(OR(M4="",M4="void"),"",(M4-J4))
Rdawbrey
Posted : 07/04/2017 12:01 pm
