Right. That also has the benefit of being more flexible, if the percentages,
or ranges, change.

Dave
--
Brevity is the soul of wit.


"willwonka" wrote:

Another thought is to use a Lookup Table. Creat a table that looks
like this.

Colunm A Column B
0 .005
55000 .01
250000 .015
400000 .02

Give it a range name of data. You can then use this formula

=a1*vlookup(a1,data,2)


Dave F wrote:
=IF(A1<=55000,A1*.005,IF(AND(A155000,A1<=250000), A1*.01,IF(AND(A1250000,A1<400000),A1*.015,A1*.02) ))

Dave
--
Brevity is the soul of wit.


"TamIam" wrote:

I was wondering if you could help me? How would I express this in an Excel
statement?:

Rates are as follows:
Up to 55,000 x .5% of total property value
from 55,000 to 250,000 x1% of total property value
from 250,000 to 400,000 x1.5% of total property value
from 400,000 and up x 2% of total property value


--
Thanks for your help!