Adding a third parameter to IF

[CDandVinyl]

I'm using this expression in my worksheet to make certain entries based upon the amount of days between the date in B4 and today's date :

Please Login or Register  to view this content.

It works fine , but I need to add an extra parameter to this formula to say that if G4= "P" then put nothing.

Can someone advise on how to adjust my formula to accommodate this?

Grateful for any help.

[AliGW]

Try this:

=IF(G4="P","",IF(DATEDIF(B4,TODAY(),"D")<31,(DATEDIF(B4,TODAY(),"D")), ">31"))

[Pepe Le Mokko]

Try =IF(G4="P","",IF(DATEDIF(B4,TODAY(),"D")<31,(DATEDIF(B4,TODAY(),"D")), ">31"))

[CDandVinyl]

Perfect - thanks guys.