LinkBack URL
About LinkBacks
I am not sure if I am setting this correctly or if you just cannot have this many arguments in this function. How would I write a function for multiple arguments? Thank you for your help
=IF((E5/E6)<=1,-0.5,IF((E5/E6)<4,-0.3),IF((E5/E6)>=4,-0.2))
I am not sure if I am setting this correctly or if you just cannot have this many arguments in this function. How would I write a function for multiple arguments? Thank you for your help
=IF((E5/E6)<=1,-0.5,IF((E5/E6)<4,-0.3),IF((E5/E6)>=4,-0.2))
Try it like this...
=IF(E5/E6<=1,-0.5,IF(E5/E6<4,-0.3,-0.2))
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Perfect! Thank you for your help.
Try the lookup...
best for shortening if.. functions like this..
Formula:
Please Login or Register to view this content.
Don't forget to click *
You're welcome. Thanks for the feedback!
If your question has been solved please mark the thread as being solved.
In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.
Vikas, that wont work for all values...
PHP Code:1....3....8....E5
2....2....2....E6
0.5..1.5..4..E5/E6
#N/A..-0.5..-0.3..Your answer
-0.5..-0.3..-0.2.Should be
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks