Multiple IF statements in equation

  • Thread starter Thread starter WA
  • Start date Start date
W

WA

Hello,

I have this simple equation in excel where I have tested the individual
segments - I know it works, but when I put it into excel, it tells me there's
an error. If anyone has ideas, let me know - Thanks.

Below is the equation

=IF (C57>0, IF(C59>0, ((C59/C57)^(0.5))-1, IF (C57<0, IF(C59<0,
(((C59/C57)^(0.5))-1)*-1, IF(C57<0, IF(C59>0, (((ABS(C57) + ABS(C57) + C59)/
ABS(C57) ) ^0.5)-1, IF(C57>0, IF(C59<0, ((((C57 + C57 + ABS(C59)) /C57) ^0.5)
-1) *-1, ""))))))))
 
If you are in Excel 2003 or earlier, you have too many levels of
parentheses; they are nested too deeply. You need to rewrite the
formula such that it uses few levels of nested parentheses or you need
to split the formula in two (or more) cells.

Excel 2007 supports up to 64 levels of parents.

Cordially,
Chip Pearson
Microsoft MVP 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com
[email on web site]
 
Back
Top