nesting conditional formulas

[Guest]

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.

 

[Bob Phillips]

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)

 

[Guest]

My bad, I worded that question wrong.
I looked up the VLOOKUP and I still don't understand. Here is some more
clarity.

In cell C1, I'm trying to create a formula that will take the value of cell
B1 and multiply it by a number, dependant upon the beginning value of cell
B1.

What I am trying to do it show what the markup value for our products should
be. If they COST (listed in cell B1) us less than a dollar, then the markup
should be 500% (multiply by 6) to be displayed in cell C1. if the cost (B1)
is 1.00-3.00, then multiply by 5, if the cost is 3.01-5.00, multiply by 4,
etc...

I did this formula once before, but it was a terribly long time ago and I've
since lost it.

Thanks for your reply.

 

[Guest]

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(B1>3.00,
B1<5.01),B1*4,0))