Hi,

If your number of $250,000 is placed in cell A1, paste this formula in
cell B1

=IF(A1<55000,316.25,IF(A1<100000,316.25+(5.75*(ROU ND(A1-55000,-3)/1000)),(316.25+5.75*((100000-55000)/1000)+5*(ROUND(A1-100000,-3)/1000))))

Note that the formula rounds off the variance to nearest thousand.

Regards

Govind.

DG wrote:
It starts out at a flat fee of $316.25 for everything from 0 to $55,000.00,
and then adds $5.75 per $1,000.00 up to a maximum of $100,000 and then
anything over $100,000 the rate drops to $5.00 per $1,000 up to 1 million.

What I am attempting to do is place a number like $250,000 in a box and have
excel do the equation and automatically place $1,325.00 in another box.