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)
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)