3 ifs in one statement

J

JBS

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
 
B

Bob Phillips

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

--
HTH

Bob Phillips

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

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.
Click to expand...

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________
 
Top