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! *