Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
My if statement is as follows:
=if(and(a0,c0),((a*b)+(c*d))/e,(if(a=o,c*d/e,(if(c=0,a*b/e,""))))) It works fine for all of the conditions except for the case where none of the parameters are true. I want it to return a blank space, instead it is returning "value". I have tried substituting the blank space with a number or word and it still returns "value". Can anyone see the error. Thank you |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to: Multiple "if" statements? | New Users to Excel | |||
How do I set up multiple if statements in Excel? | Excel Worksheet Functions | |||
Logical Function - Multiple IF statements | Excel Worksheet Functions | |||
Combining IF and multiple SUMIF statements, if A>0 & B is between | Excel Worksheet Functions | |||
multiple IF statements | Excel Worksheet Functions |