| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
if today = then
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 |
|
#2
|
|||
|
|||
Quote:
Try to use this one: A3 -- =IF(TODAY()=A1,A2,"")
__________________
I hope it can help you. Best regards, Marcilio Lobão --------------------------- Belo Horizonte, Brazil |
|
#3
|
|||
|
|||
|
Quote:
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF TODAY()< | Excel Worksheet Functions | |||
| today | Excel Discussion (Misc queries) | |||
| IF TODAY equals date in cell A10, or if TODAY is beyond that date | Excel Worksheet Functions | |||
| TODAY() | Excel Worksheet Functions | |||
|
=IF(OR(TODAY() |
Excel Discussion (Misc queries) | |||
Linear Mode
