YTL Excel #115: Time Delayed Formula TODAY & IF functions

[2009jaxs]

I came across another road block in regards to cell P9 & C9.

Cell P9 is blank with a general number format.

When I enter a number >0 then I want the date & time to appear in cell C9 but not before.

I have tried;

1) =IF(P9="","",NOW()) which give me the date & time with out an entry in P9.

2) =IF(P9="","",C9=NOW()) which when P9 is blank C9 is blank, when I enter a number value C9 read false.

3) =IF(P9>0,0,C9=NOW()) which give me a false.

what I am I doing wrong, forgetting and/or missing.

[ExcelIsFun]

I am currently overwheled at work (80+ hours per week).. No time.. Try:

mrexcel[dot]com/forum