IF & ROUNDUP functions

Originally Posted by stevemel

Hi Can anyone help

I have a spreadsheet with the cost of properties on, I need to add a percentage on according to the value, if the result value is less than 750, i need a formula to round up to 750.

example:
property values upto 19,999 need plus 8%
property values 20,000-60,000 need plus 5%
property values 61,000-100,000 need plus 3%
over 101,000 plus 2%
I need a formula that looks up the figures in a cell and calculate the above accordingly, if thats possible, then to perform the function below.

If the resulting total doesn't reach 750 then i need to roundup to 750.

I trust this makes sense to someone, if so please help.

Thank you
Steve

Hi try following formula (if you enter figure in cell A1)

=IF(A1<750,750,IF(AND(A1>750,A1<20000),A1*1.08,IF(AND(A1>=20000,A1<=60000),A1*1.05,IF(AND(A1>=61000,A1<=100000),A1*1.03,A1*1.02))))