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+(SUM(A1:D1)-2)*3000))

--

HTH

Bob Phillips

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

1000+(((a+b+c+d)-2)*300)

--

HTH

Bob Phillips

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

1000+(((a+b+c+d)-2)*300)

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

with.

with.

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

__

Richard Buttrey

Grappenhall, Cheshire, UK

__________________________

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

__

Richard Buttrey

Grappenhall, Cheshire, UK

__________________________

1. Sorry about the last ones...And statements with IF's

2. New IFS interface (jfs.ifs, udf.ifs for example)

3. Case statement ? - to replace nested ifs ?

4. multiple ifs converted to case statement in vb function

6. Why isn't the If's statement, after the expression, being executed?

7. IF Statement (Nested IF's??)

8. what is the max no. of nested Ifs can an If Statements have in EXC

9. Nested If's vs. GoTo statements

10. What does IFS="${IFS}[]()" mean?

11. IFs, ELSEs, END IFS -- proper construction

12. Why there is a need of IFS and non-IFS LSP sockets?

13. Editing and Moviing from 6 If's to 7 Ifs (Nested)

15. differecnce between ${IFS} and "${IFS}"

4 post • Page:**1** of **1**