I am trying to produce a formula that does the following:

If the value of (a+b+c+d) = 1 then cell e must show 500
if the value of (a+b+c+d) = 2 then cell e must show 1000
if the value of (a+b+c+d) <= 3 then cell e must show 1000+(((a+b+c+d)-2)*300)
How do I nest the ifs correctly to get this.

Thank you
JBS

=IF(SUM(A1:D1)=1,500,IF(SUM(A1:D1)=2,1000,1000+(SU M(A1:D1)-2)*3000))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"JBS" wrote in message
...
I am trying to produce a formula that does the following:

If the value of (a+b+c+d) = 1 then cell e must show 500
if the value of (a+b+c+d) = 2 then cell e must show 1000
if the value of (a+b+c+d) <= 3 then cell e must show
1000+(((a+b+c+d)-2)*300)
How do I nest the ifs correctly to get this.

Thank you
JBS

Thank you. This is much neater and works better than what I was struggling
with.


"Bob Phillips" wrote:

=IF(SUM(A1:D1)=1,500,IF(SUM(A1:D1)=2,1000,1000+(SU M(A1:D1)-2)*3000))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"JBS" wrote in message
...
I am trying to produce a formula that does the following:

If the value of (a+b+c+d) = 1 then cell e must show 500
if the value of (a+b+c+d) = 2 then cell e must show 1000
if the value of (a+b+c+d) <= 3 then cell e must show
1000+(((a+b+c+d)-2)*300)
How do I nest the ifs correctly to get this.

Thank you
JBS

I think there was a typo in Bob's response. Check this if you've
copied and pasted Bob's string. The last multiplier should be 300 not
3000.

Rgds



On Thu, 29 Jun 2006 01:55:02 -0700, JBS
wrote:

Thank you. This is much neater and works better than what I was struggling
with.


"Bob Phillips" wrote:

=IF(SUM(A1:D1)=1,500,IF(SUM(A1:D1)=2,1000,1000+(SU M(A1:D1)-2)*3000))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"JBS" wrote in message
...
I am trying to produce a formula that does the following:

If the value of (a+b+c+d) = 1 then cell e must show 500
if the value of (a+b+c+d) = 2 then cell e must show 1000
if the value of (a+b+c+d) <= 3 then cell e must show
1000+(((a+b+c+d)-2)*300)
How do I nest the ifs correctly to get this.

Thank you
JBS




__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________