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="" ")))
<tbody>
</tbody>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>
=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="" ")))
26 October 2017 | OK | |
27 October 2017 | OK | |
28 October 2017 | £50.00 | OK |
14 October 2017 | Due Today | |
14 October 2017 | Due Today | |
14 October 2017 | Due Today | |
14 October 2017 | Due Today | |
Overdue | ||
Overdue | ||
Overdue | ||
Overdue | ||
This column continues with the same |
<tbody>
</tbody>
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>
Last edited: