How can I add another condition (4 not 3)?

"MartinW" wrote:

Hi Lemony,

With your number in A1, your first multiply value in B1, your second
multiply value in C1 and your third multiply value in D1.
Put this in E1.
=IF(A1<=3,A1*B1,IF(AND(A13,A1<=10),A1*C1,A1*D1))

You didn't specify your exact cutoff points so you may need
to adjust the less than or equals bits.

HTH
Martin



"Lemony_M" wrote in message
...
I need to multiply a number by a value in a cell but if the number is
greater
than 3 it needs to be muliplied by a value in a different cell if that
makes
any sense at all!!
I also need to be able to do the above but with 3 different values (e.g
less
than three, 4 to 9 and greater than 10) Please help as I am getting very
annoyed with myself!!