3 ifs in one statement

[Guest]

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

 

[Bob Phillips]

=IF(SUM(A11)=1,500,IF(SUM(A11)=2,1000,1000+(SUM(A11)-2)*3000))

--
HTH

Bob Phillips

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

 

[Guest]

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

 

[Richard Buttrey]

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

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

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________