Mazzaropi

Senior Member

Location: Belo Horizonte, Brazil

Posts: 170

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,"")

__________________
I hope it can help you.

Best regards,
Marcilio Lobão
---------------------------
Belo Horizonte, Brazil

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
IF TODAY()<	[email protected]	Excel Worksheet Functions	3	February 6th 09 01:36 PM
today	stew	Excel Discussion (Misc queries)	4	September 19th 08 06:15 PM
IF TODAY equals date in cell A10, or if TODAY is beyond that date	SoupNazi	Excel Worksheet Functions	4	April 23rd 07 01:14 AM
TODAY()	alex	Excel Worksheet Functions	2	January 31st 07 02:11 PM
=IF(OR(TODAY()G9),"Pass","Overdue") Why doe it not wo.	Fkor	Excel Discussion (Misc queries)	3	March 10th 05 08:29 AM

All times are GMT +1. The time now is 07:01 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us