You can't use a formula in a cell that uses that cell's original value. It
cannot have both a value and a formula.

If you can use other cells, take a look at VLOOKUP in help, it will do what
you want.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

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