Hope I posted this to the write place. Need help with writing a formula
for a cell. I'm ok with basic stuff, but I think this is one of those
If, then kind of formula's and don't have a clue on writing them.

I have a total amount in one cell, call it A20. In another cell I need
a formula that will take the amount in A20, and based on the amount of
it, calculate a down payment. Here are the specifications for it.

If A20 is less than $2000, the full amount is the down payment.

If A20 is between 2000 and 4999, 1/2 of it is the down payment.

If A20 is between 5000 and 9999, 1/3 of it is the down payment.

If A20 is equal or greater than 10000, 1/4 of it is the down payment.

In each case, rounded to nearest dollar amount.

If you could help me write this, that would be great. Thanks in
advance.


--
TxJprs
------------------------------------------------------------------------
TxJprs's Profile: http://www.excelforum.com/member.php...o&userid=25710
View this thread: http://www.excelforum.com/showthread...hreadid=391276