Help with formula w multiple IFs

[Laavista]

I really need your help!

The following formula works:
=IF(F7="NR",R7-T7,IF(F7="OR",R7-T7,IF(F7="PR",R7-T7,IF(F7="SR",R7-T7,””))))

I need to add, though, that if there is nothing (no date) in cell R7, then this cell should be left blank. I have the following formula and it's not working:

=IF(R7<>””,(IF(F7="NR",R7-T7,IF(F7="OR",R7-T7,IF(F7="PR",R7-T7,IF(F7="SR",R7-T7,””))))))

This should read:
if cell R7 does not have a date, then leave this cell blank
if cell R7 DOES have a date then:
if F7 is equal to NR, then subtract date in R7 against date in T7
else
if F7 is equal to OR, then subtract date in R7 against date in T7
else
if F7 is equal to PR, then subtract date in R7 against date in T7
else
if F7 is equal to SR, then subtract date in R7 against date in T7
else
leave this cell blank (F7 is something other than NR, OR, PR, or SR)

Any help would GREATLY be appreciated!

 

[rwould]

=IF(AND(NOT(ISBLANK(R7)),OR(F7="NR",F7="OR",F7="PR",F7="SR")),R7-T7,"")

I am not checking if R7 is a date, just whether it is empty or not. Checking it for a date is more complicated and if it is either full or empty (as your question implies) this should suffice.

 

[Arthur.J]

Hey,

Try:

=IF(R7<>"",IF(F7="NR",R7-T7,IF(F7="OR",R7-T7,IF(F7="PR",R7-T7,IF(F7="SR",R7-T7,””)))),"")

 

[JackDanIce]

Try:

=IF(NOT(ISBLANK(R7)),IF(OR(F7="NR",F7="OR",F7="PR",F7="SR"),R7-T7,""))

 

[Laavista]

Re: Help with formula w multiple IFs SOLVED

Wow-- all three solutions worked. I am so impressed. THANK YOU so much for taking the time to respond to my question. I spent a long time trying to get this formula to work (to no avail), and I urgently needed this info.

THANKS.