Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Pat
 
Posts: n/a
Default IF Statement that's conditional on multiple IF Stmts in other cell

Hi all,

-I have an IF Stmt in Cell G97 that reads: =IF(M96=0,"",G96+1)
-M96 also has an IF Stmt that reads: =IF(G96<=$D$31*$D$32,M95+K96-L96,"")
-L96 has an IF Stmt that reads: =IF(G96<=$D$31*$D$32,$D$30,"")
-K96 has an IF Stmt that reads: =IF(G96<=$D$31*$D$32,J96,"")
-J96 has an IF Stmt that reads: =IF(G96<=$D$31*$D$32,$L$79*M95,"")
-G96 starts the whole process over [ =IF(M95=0,"",G95+1) ] and this process
repeats for about 40 rows.

My problem is that when any of the cells in Column M actually do =0, the
formula in Column G does not do what it is supposed to do. Instead of
leaving the cell blank, it does the "False" part, G96+1. Is this because I
have IF Stmts in Column G,H,I,J,K,L, and M? All of them work off each other.
All of my cells are formated to be "Number" cells with no decimal places.

But I still don't see why Excel isn't following my IF Stmt in Column G. One
person, Bob, suggested using "LEN" in my If Stmt, but that didn't do the
trick unfortunately. Any suggestions? I am lost! Any and all help is
appreciated.

Thanks, have a great weekend!
-Pat
  #2   Report Post  
JE McGimpsey
 
Posts: n/a
Default

It's probably not a direct consequence of the IF()s , but if there are
small rounding errors, perhaps M96 is not actually zero.

Try:

=IF(ROUND(M96,10)=0, "",G96+1

adjust the number of digits to suit.

In article ,
Pat wrote:

Hi all,

-I have an IF Stmt in Cell G97 that reads: =IF(M96=0,"",G96+1)
-M96 also has an IF Stmt that reads: =IF(G96<=$D$31*$D$32,M95+K96-L96,"")
-L96 has an IF Stmt that reads: =IF(G96<=$D$31*$D$32,$D$30,"")
-K96 has an IF Stmt that reads: =IF(G96<=$D$31*$D$32,J96,"")
-J96 has an IF Stmt that reads: =IF(G96<=$D$31*$D$32,$L$79*M95,"")
-G96 starts the whole process over [ =IF(M95=0,"",G95+1) ] and this process
repeats for about 40 rows.

My problem is that when any of the cells in Column M actually do =0, the
formula in Column G does not do what it is supposed to do. Instead of
leaving the cell blank, it does the "False" part, G96+1. Is this because I
have IF Stmts in Column G,H,I,J,K,L, and M? All of them work off each other.
All of my cells are formated to be "Number" cells with no decimal places.

But I still don't see why Excel isn't following my IF Stmt in Column G. One
person, Bob, suggested using "LEN" in my If Stmt, but that didn't do the
trick unfortunately. Any suggestions? I am lost! Any and all help is
appreciated.

Thanks, have a great weekend!
-Pat

Reply
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 Statement equalling multiple words. Please Help Phillip Vong Excel Discussion (Misc queries) 4 March 18th 05 01:43 AM
Help, Multiple conditional calculation wwj New Users to Excel 4 March 10th 05 10:05 PM
Multiple FIND functions in Conditional Formatting RocketFuMaster Excel Worksheet Functions 2 March 2nd 05 07:09 PM
How to create Multiple Conditional Formulas in a single cell? Maxfx Excel Discussion (Misc queries) 2 February 1st 05 03:26 PM
Copy conditional formatting across multiple rows? Gil Excel Discussion (Misc queries) 1 January 11th 05 12:27 PM


All times are GMT +1. The time now is 06:53 PM.

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

About Us

"It's about Microsoft Excel"