View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
WA WA is offline
external usenet poster
 
Posts: 37
Default Multiple IF statements in equation

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 (C570, IF(C590, ((C59/C57)^(0.5))-1, IF (C57<0, IF(C59<0,
(((C59/C57)^(0.5))-1)*-1, IF(C57<0, IF(C590, (((ABS(C57) + ABS(C57) + C59)/
ABS(C57) ) ^0.5)-1, IF(C570, IF(C59<0, ((((C57 + C57 + ABS(C59)) /C57) ^0.5)
-1) *-1, ""))))))))