Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Ag120 is greater than r4 ithe cell should populate with ""
what do you want it to do? "AlanStotty" wrote: Hi, I am using the following calculation in the field: =IF($AG120 =R$4, "", IF($AH120 <=R$4, "", "need")) where AG120 = 23/01/2007, R4 = 01/01/2007 and AH120 = 02/09/2007. But it does not seem to populate with "need". Any ideas? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
User Defined Charts-Missing the "Add-Delete" Options. | Excel Discussion (Misc queries) | |||
User Defined Charts-Missing the "Add-Delete" Options. | Excel Discussion (Misc queries) | |||
Scroll Bar missing "Control" tab in "Format Properties" dialog box | Excel Discussion (Misc queries) | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel |