IF formula for 3 possible conditions
Excellent, thanks!
"pinmaster" wrote:
Hi
Here's a shorter version:
=IF(V71000,V7+80,IF(V7200,V7*108%,IF(V70,V7+16, 0)))
Cheers
Jean-Guy
"cbgraphics" wrote:
Perfect, thanks for your help.
"Hank Scorpio" wrote:
On Wed, 27 Dec 2006 15:07:02 -0800, cbgraphics
wrote:
I'm trying to setup a formula as follows:
If the value referenced is between 1 and 200, it will add 16 to itself; if
it is between 201-1000, it will multiply itself by 108%; if it is 1001 or
greater it will add 80 to itself.
I originally set it up as:
=IF(V7<201,V7+16)+IF(V7=201,1000,V7*108%)+IF(V71 000,V7+80)
but this formula only works for the middle condition (values between 201 and
1000).
I'm going crazy, what am I doing wrong?
You don't add If formulas to work out alternatives, you use the True
or False arguents. These can be "nested" up to 7 levels so that if the
first test (<201) fails, you try the If function in the False argument
and so on.
I think this is what you're after; it should be fairly self
explanatory:
=IF(AND(V7=1,
V7<=200),V7+16,IF(AND(V7=201,V7<=1000),V7*108%,IF (V7=1001,V7+80,"Undefined")))
I've added the And functions to show the range that each formula
applies to.
---------------------------------------------------------
Hank Scorpio
scorpionet who hates spam is at iprimus.com.au (You know what to do.)
* Please keep all replies in this Newsgroup. Thanks! *
|