P
PaulaCMT
Hi there
Here is my problem.....
=IIf([Propertyvalue] Between "1" And "100000","£240",IIf([Propertyvalue]
Between "100001" And "150000","£280",IIf([Propertyvalue] Between "150001" And
"200000","£330",IIf([Propertyvalue] Between "200001" And
"250000","£360",IIf([Propertyvalue] Between "250001" And
"300000","£380",IIf([Propertyvalue] Between "300001" And
"400000","£470",IIf([Propertyvalue] Between "400001" And
"500000","£520",IIf([Propertyvalue] Between "500001" And
"600000","£580",IIf([Propertyvalue] Between "600001" And
"700000","£650",IIf([Propertyvalue] Between "700001" And
"800000","£725",IIf([Propertyvalue] Between "800001" And
"900000","£780",IIf([Propertyvalue] Between "900001" And
"1000000","£895","0"))))))))))))
This works fine except for values less than 100,000. For example 90,000
returns a fee of £780 instead of £240.
Can anyone please help me with this or maybe suggest a better way of doing
it??
Thank you in advance
Paula
Here is my problem.....
=IIf([Propertyvalue] Between "1" And "100000","£240",IIf([Propertyvalue]
Between "100001" And "150000","£280",IIf([Propertyvalue] Between "150001" And
"200000","£330",IIf([Propertyvalue] Between "200001" And
"250000","£360",IIf([Propertyvalue] Between "250001" And
"300000","£380",IIf([Propertyvalue] Between "300001" And
"400000","£470",IIf([Propertyvalue] Between "400001" And
"500000","£520",IIf([Propertyvalue] Between "500001" And
"600000","£580",IIf([Propertyvalue] Between "600001" And
"700000","£650",IIf([Propertyvalue] Between "700001" And
"800000","£725",IIf([Propertyvalue] Between "800001" And
"900000","£780",IIf([Propertyvalue] Between "900001" And
"1000000","£895","0"))))))))))))
This works fine except for values less than 100,000. For example 90,000
returns a fee of £780 instead of £240.
Can anyone please help me with this or maybe suggest a better way of doing
it??
Thank you in advance
Paula