I KNOW that the following formula is incorrect, but can someone at least tell
me if if I'm on the right track?

=OR(IF(B1<1, B1*6, 0)),IF(OR(B1.99, B1<3.01), B1*5,0),IF(OR(B13.00,
B1<5.01),B1*4,0))

"Nancy" wrote:

I am trying to create a complicated formula which will look at a cell and
multiply it by a number which is dependant upon what the number in the
original cell is.

For example, if B2 is 99 or less, then multiply by 6. If it is between 1
and 3, then multiply by 5, if it is between 3.01 and 5, then multiply by 4,
etc.

All in all, there would be about 10 of those situations, but if I can get
some help starting it off, I can finish it up.

Thanks in advance.