Hi all. Kind of a basic user of excel here, hoping someone more advanced
than I (not saying much) on this forum can help me with a formula to us
in a worksheet to calculates the appropriate transfer taxes when you
plug in the purchase price in, say cell B1. Following is the tax rate
structu (Thanks in advance for any help!!)

(a)$0.90 for each $500.00 of purchase price or fractional part thereof
recited in the deed that is not in excess of $550,000.00, except that
in the case of a conveyance or transfer of property for which the total
consideration recited in the deed does not exceed $350,000.00, no
general purpose fee shall be imposed;

(b)$1.40 for each $500.00 of purchase price or fractional part thereof
in excess of $550,000.00 but not in excess of $850,000.00 recited in
the deed;

(c)$1.90 for each $500.00 of purchase price or fractional part thereof
in excess of $850,000.00 but not in excess of $1,000,000.00 recited in
the deed; and

(d)$2.15 for each $500.00 of purchase price or fractional part thereof
in excess of $1,000,000.00 recited in the deed


--
mynew06
------------------------------------------------------------------------
mynew06's Profile: http://www.excelforum.com/member.php...o&userid=37788
View this thread: http://www.excelforum.com/showthread...hreadid=573548