how do I write a better formula?

[samlee1981]

I have the following If formula...

[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]=IF(D5-15<P$3,"OVERDUE","NOT DUE")=IF(J5=isnumber,I5,"")

How do I write this correctly?
The first part works but the second nested IF is not correct.

D Column is course date, I Column is todays date minus 15 days (set to remind me that payment needs to have been made), J Column is payment received. P3 is todays date.

I want to say - if J5 contains a number, (e.g the date payment was received), make I5 blank. At the moment it just says overdue.


Any ideas how to reword it?

Many thanks
[/FONT]

 

[gaz_chops]

If you are using < or > in your formula, put a space either side when posting it on the forum, otherwise it will cut it off at the < >

 

[samlee1981]

[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]=IF(D5-15<P$3,"OVERDUE","NOT DUE")=IF(J5=isnumber, I5="")[/FONT]

 

[samlee1981]

for some reason, I can't copy whole of if formula over to show you!

 

[AlanY]

for some reason, I can't copy whole of if formula over to show you!

instead of

=if(B1>5, "Yes","No")

put extra spaces like this

=if(B1 > 5, "Yes","No")

 

[samlee1981]

[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]=IF ( D5-15 < P$3, " OVERDUE", " NOT DUE")= IF ( J5 = isnumber, I5 ="" )[/FONT]

 

[gaz_chops]

Maybe

=if(isnumber(J5),"",IF (D5-15 < P$3,"OVERDUE","NOT DUE"))

 

[samlee1981]

it works! very grateful. thanks!

 

[gaz_chops]

You're welcome.