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(V710 00,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?

Thanks in advance for any guidance.

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

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

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

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

Hello,

Another approach:
=CHOOSE((V71000)+(V7200)+(V70),V7+16,V7*1.08,V7 +80)

Regards,
Bernd

Thank you as well!

" wrote:

Hello,

Another approach:
=CHOOSE((V71000)+(V7200)+(V70),V7+16,V7*1.08,V7 +80)

Regards,
Bernd