Check out this web page of John McGimpsey on the subject:

http://www.mcgimpsey.com/excel/variablerate.html

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Peter P" <Peter wrote in message
...
Mike H:

Seeking to properly formulate a logical function to bifurcate or seperate
an
amount contained in a referenced cell for purposes of calculating an
amount
based upon each of the various layers.

For example, the number to be referenced is say 12,000,000 sitting in cell
c5 of the spreadsheet.

I wish to calculate 3% of the first 1,000,000 of that value; then 2.5% of
the amount greater than the first 1,000,000 of that 12,000,000, but not
more
than 5,000,000 of that number; then 2% of the amount in excess of
5,000,000
yet not more than 10,000,000; and finally, 1.5% of the value in cell c5
greater than 10,000,000.

It seems to be amenable to a nested IF and AND function, yet I'm
apparently
a bit stymied over proper syntax... any help would be greatly appreciated.

Thanks.

Peter P.

"Mike H" wrote:

Maybe

=IF(AND(B6="M",C6="L"),"Moved Down from Medium",IF(AND(B6="M",C6="M"),"No
Movement",""))

If's can be nested up 7 deep.

Mike

"hmlguru" wrote:

Is it possible to connect more than one formula to a cell? I am fairly
new at
this. I have the following formula that works perfectly:

=IF(AND(B6="M",C6="L"),"Moved Down from Medium")

I need to know how to add another formula to the same cell if
B6="M",C6="M"
and my result would be "No Movement"

How many separate formulas can apply to one cell?