Prev Previous Post   Next Post Next
  #1   Report Post  
bjd via OfficeKB.com
 
Posts: n/a
Default Nested if

I have put together an if statement:

=IF(AND(U8="08",M8/AB8<$O$5),"Problem",IF(AND(B8="Base",M8/AB8<$O$4),
"Problem",IF(AND(B8="RDC",M8/AB8<$O$4),"Problem",IF(AND(B8="Branch",M8/AB8<$O
$3),"Problem","OK"))))

the statement works but not as intended. The only
issue is that I want the first condition as sort of
an overall condition, that if met, none of the other
conditions need to be cycled through. If not
met, then cycle through the other functions.

The logic is to look at the value in U8 and if it
equals "08" and it is less than 31 (m8/ab8), display
"Problem". If not equal to "08", then apply the other
IF(And functions, that look at conditions in a different
column.

The issue is that I have not figured a way
keep it from cycling through the other conditions. I've
tried some "OR" conditions but I can't get it to work.

Any suggestions would be appreciated.
 
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
Limited IF Nested Level functions. Skyscraper Excel Discussion (Misc queries) 1 April 8th 05 12:35 PM
Nested IF statements John Simons Excel Worksheet Functions 14 February 16th 05 06:17 AM
how can I exceed the nested if fuction limit mgdye Excel Discussion (Misc queries) 5 January 30th 05 02:09 PM
€śUse of more then 7 nested if statement€ť Faisal Yameen Excel Worksheet Functions 3 January 12th 05 06:02 PM
nested ifs sthompson Setting up and Configuration of Excel 1 December 15th 04 06:38 PM


All times are GMT +1. The time now is 05:31 AM.

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"