Hi,
Try

=IF(B1<250,(B1*A1),IF(B1<500,(B1*A2),IF(B1=500,(B 1*C2))))

"Peterest" wrote:

Hi Guys,
What a very helpful bunch of guys.
I would appreciate help on this one


Cells A1,A2 and C2 contain the numbers 5, 10 and 15 respectively.
These numbers relate to the price of something which is conditional on the
number in B1. e.g if B1 is 249 or less A1 is 5, if B1 is between 249 and 499
then A2 is 10, if 500 or higher than 500 C2 is 15

Cell B1 can contains any number -- say, for example 250

Cell C1 should display the answer to cell B1multiplied by either 5, 10 or
15, depending on the number in B1.

Help please!!

Cell C1 is the answer to the formu
Peterest