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?