Nested If's

B

Brad@zelle

I have a three level nested If with Max functions nested as well. When I use the Functions Arguement dialog box to build this I get to the second level if and first level max functions and when I click ok it kicks me back to the cell. Is there any way that I can drill in and drill back out in the Functions dialog box to complete this formula

Here is an example of the formula

IF(B32>0,IF(B33>-1,IF(-(B30+B31)>B32,-B32,-MAX(B32,B30+B31)),-MAX(B32+B33,B30+B31)),0)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Increment by 18 1
Page numbering with Merged Document and IF statements 1
Help to create biweekly dates excluding nonworking days 2
HLP - Dynamic Range for Nested IF 1
Excel 2007 problem nesting IF & AND 0
Nested IF & MAX Function 4
Excel 2007 balks at >7 nested IFs 5
Excel message box 5

Top