I assume that you are using Martin's formula but just for completeness with
my formula change it to:

(sorry I forget to say to put the values that you want to multiply by in
E11:H11)

=B11*IF(B1110,E11,IF(B117,G11,IF(B113,G11,H11)) )

or:

=B11*IF(B1110,3,IF(B117,5,IF(B113,9,11)))

Bu tit is btter/easier to put the multiplcation values in cells because they
can be changed without having to find all the individual formulas

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Lemony_m" wrote in message
...
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!!