Help on Formulae

[LesHunter]

Hi,I have a problem i'm trying to solve and I expect it will take someone 5 minutes to figure out,But not me, I am just learning Excel and its wonderful ways it can automate so much.
=IF(TODAY()>E12,"Overdue",IF(TODAY()<e12,"ok",if(today()=e12,"due today="" ")))
continues
<E12,"OK",IF(TODAY()=E12,"Due Today ")))
I am trying to have column which when certain parameters are met the appropriate message appears(so far so good) it works for me,
However as I have copied down the column the "default" is shown even though it appears that the formulae is correct.
What I need is for the column to show nothing until a date is input in the adjoining cell
<e12,"ok",if(today()=e12,"due today="" ")))

<e12,"ok",if(today()=e12,"due today="" ")))=""
<e12,"ok",if(today()=e12,"due today="" ")))


[TABLE="width: 382"]
<tbody>[TR]
[TD]26 October 2017[/TD]
[TD][/TD]
[TD]OK[/TD]
[/TR]
[TR]
[TD]27 October 2017[/TD]
[TD][/TD]
[TD]OK[/TD]
[/TR]
[TR]
[TD]28 October 2017[/TD]
[TD]£50.00[/TD]
[TD]OK[/TD]
[/TR]
[TR]
[TD]14 October 2017[/TD]
[TD][/TD]
[TD]Due Today[/TD]
[/TR]
[TR]
[TD]14 October 2017[/TD]
[TD][/TD]
[TD]Due Today[/TD]
[/TR]
[TR]
[TD]14 October 2017[/TD]
[TD][/TD]
[TD]Due Today[/TD]
[/TR]
[TR]
[TD]14 October 2017[/TD]
[TD][/TD]
[TD]Due Today[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Overdue[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Overdue[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Overdue[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Overdue[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]This column continues with the same[/TD]
[/TR]
</tbody>[/TABLE]
What I need is for the column to be clear until a date is put into the date field,
The date is filled in automatically from my invoice, This is an invoice register.

<e12,"ok",if(today()=e12,"due today="" ")))
<e12,"ok",if(today()=e12,"due today="" ")))
Any help would be most gratefully received as ever
les hunter </e12,"ok",if(today()=e12,"due></e12,"ok",if(today()=e12,"due></e12,"ok",if(today()=e12,"due></e12,"ok",if(today()=e12,"due></e12,"ok",if(today()=e12,"due></e12,"ok",if(today()=e12,"due>

 

[FDibbins]

Based on your sample formula, try this...
=if(E12="","",IF(TODAY()>E12,"Overdue",IF(TODAY() continues....

Also, it might be better to put +TODAY() in it's own cell, then reference that cell. =TODAY() is volatile (calcs with any workbook change), and could slow your file down if used extensively. To maybe something like...
=if(E12="","",IF($A$1>E12,"Overdue",IF($A$1continues....

 

[LesHunter]

Hi Ford, nice to meet your acquaintance.
Thank you very much for your help with my formulae, it worked a treat.
i have used the snippet to do the same with another formulae so the learning curve goes on.

once again thank you for your help it is very,very much appreciated.

 

[FDibbins]

Nice to meet you too, and Im happy I could assist you