| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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, "")))))))) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup equation on multiple tabs | Excel Discussion (Misc queries) | |||
| Vlookup equation for multiple tabs | Excel Discussion (Misc queries) | |||
| Multiple Fonts in Excel Equation | Excel Worksheet Functions | |||
| graph multiple superposition equation | Charts and Charting in Excel | |||
| Is there an equation in Excel to use multiple if then statements? | Excel Discussion (Misc queries) | |||
Threaded Mode
