Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I don't understand why this formula does not work
Cell D 10 is =IF(B10=1,$G$72,(IF(AND(D11=0,D9=$G$72),$G$71,0)) ) Cell D 11 is =IF(B11=1,$G$72,(IF(AND(D12=0,D10=$G$72),$G$71,0) )) Cell D 12 is =IF(B12=1,$G$72,(IF(AND(D13=0,D11=$G$72),$G$71,0) )) If I check off display zero values in my options menu then I do see a zero in the cell but the formula does not read it as a zero. The only way I know it doesn't is when I type in a zero in cell D 12 then cell D 11 reacts the way I expect it to.... Is there something I don't understand about formula writing or is this one of those so called glitches? This is what it looks like when the formula is working on its own Total Kms for the Day 76 ___________________________________________ This is what it looks like when I type in a zero in cell D 12 Total Kms for the Day 76 Total Kms to date 76 0 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
IF Statements (Mutliple Statements) | Excel Worksheet Functions | |||
If statements | Excel Discussion (Misc queries) | |||
IF & AND statements | Excel Worksheet Functions | |||
If then statements | Excel Worksheet Functions | |||
IF Statements | Excel Worksheet Functions |