Quote:
Originally Posted by klaesser
Lets say I have four cell A1,A2,A3,A4
A1 contains a date(11/10/10 eg)
A2 contains $ data
A3 is blank
and in A4 I want a formula that asks =IF TODAY is equal to or greater than A1 then A3 is equal to A2 else blank (or 0)
Any help please
|
Dear Klaesser, Good Evening.
Try to use this one:
A3 -- =IF(TODAY()=A1,A2,"")