Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problem with =IF(AND........ formula
I have the following formula on one sheet that reads another sheet to
determine a value: =IF(AND($B$150,'Proposal Data'!$G$21="YES",'Proposal Data'!$C$7<=E12,E12<'Proposal Data'!$C$11),1,0) My problem is this......if I only have a "YES" (in the cell noted) and the other cells are blank, it is returning a "1" when it should return a "0". What have I done wrong or failed to do???? Please note the formula works fine when all cells contain data. It seems to be only the G21 cell and that d_ _ _ "YES" thats causing me the problem. For reference cells are formatted as follows: ... B15 is a number, G21 is "general" displaying blank or "YES", C7 is a date, C11 is a date, E12 is a date. All date cells are formatted MMM-YY. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Problem | Excel Discussion (Misc queries) | |||
Formula Problem | Excel Discussion (Misc queries) | |||
Help! Formula problem | Excel Discussion (Misc queries) | |||
formula problem | Excel Discussion (Misc queries) | |||
Formula problem | Excel Worksheet Functions |