LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default If And statements -- HELP!

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
IF Statements (Mutliple Statements) Deezel Excel Worksheet Functions 3 October 19th 06 06:13 AM
If statements Donna S Excel Discussion (Misc queries) 1 July 21st 06 06:21 PM
IF & AND statements hip Excel Worksheet Functions 5 June 7th 06 11:36 PM
If then statements David Bryant Excel Worksheet Functions 3 June 5th 06 10:41 PM
IF Statements Rick Scott via OfficeKB.com Excel Worksheet Functions 5 June 20th 05 02:04 PM


All times are GMT +1. The time now is 11:43 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"