Assumng that you are not trying to do it in the same cell, try:

=B9*IF(B93,E9,F9)

for the first one and:

=B11*IF(B1110,E11,IF(B113,F11,G11))

for the second example

--
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
...
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!!