LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
ddepasquale
 
Posts: n/a
Default multiple if statements

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to: Multiple "if" statements? Hosh New Users to Excel 2 June 29th 05 02:20 PM
How do I set up multiple if statements in Excel? LKraft0318 Excel Worksheet Functions 2 February 9th 05 09:53 PM
Logical Function - Multiple IF statements vnsrod2000 Excel Worksheet Functions 7 February 4th 05 10:42 PM
Combining IF and multiple SUMIF statements, if A>0 & B is between Lee Excel Worksheet Functions 1 January 3rd 05 06:46 PM
multiple IF statements Nathan McElmurry Excel Worksheet Functions 1 November 18th 04 09:22 PM


All times are GMT +1. The time now is 04:41 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"