=if(G4>120, "follow Up","") This formula is not working?

[Guest]

Excell 2003
Use the if function to place the words "Follow up" in the cell for any
invoice that is overdue by more than 120 days; otherwise, leave the cell
blank.

 

[Ron de Bruin]

Try this

=IF(G4>NOW()+120, "follow Up","")

 

[nika]

Very Strange

I just experimented with both your formulas and found that Tapping Joe
worked but Rons did no

 

[Ron de Bruin]

Hi Nika

After reading your reply I see that I don't see the whole thread in Outlook Express

 

[Guest]

Good Morning Nika,
You said that Tapping Toes formula worked. I'm sure I am missing one thing
because when I bring the handle down the column it does not show the words
"follow up".

 

[nika]

Hello Tapping Toe (sorry I called you Joe)

It's OK on mine it works fine. Is your calculation on? Tools, Options,
then the Calculation tab and check Automatic. If your set on manual
you can just press the F9 key each time you want to calculate.
Hope this works for you
let me know
good luck