P
PSU35
I have the following formula on one sheet that reads another sheet to
determine a value:
=IF(AND($B$15>0,'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.
determine a value:
=IF(AND($B$15>0,'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.