Stamp Duty
I am trying to write a formula to calculate the stamp duty in the UK as
follows for Excel 2000. Below CELL is the value of the property purchased i.e £310000 If CELL value < 250000 then answer = 1% of CELL value If CELL value =250000 and <500000 then answer = 3% of CELL value If CELL value 500000 then answer = 4% of CELL value In the above example where CELL = 310000 the answer should be 9300 Thanks for your help |
Stamp Duty
Say CELL is A1
=A1*IF(A1<250000,0.01,IF(A1<50000,0.03,0.04)) HTH -- AP "Mr Stanley (UK)" <Mr Stanley a écrit dans le message de news: ... I am trying to write a formula to calculate the stamp duty in the UK as follows for Excel 2000. Below CELL is the value of the property purchased i.e £310000 If CELL value < 250000 then answer = 1% of CELL value If CELL value =250000 and <500000 then answer = 3% of CELL value If CELL value 500000 then answer = 4% of CELL value In the above example where CELL = 310000 the answer should be 9300 Thanks for your help |
Stamp Duty
Try:
=IF(A1<250000,A1*0.01,IF(A1<=500000,A1*0.03,A1*0.0 4)) I assumed <= 500000 ss it wasn't clear from your posting HTH "Mr Stanley (UK)" wrote: I am trying to write a formula to calculate the stamp duty in the UK as follows for Excel 2000. Below CELL is the value of the property purchased i.e £310000 If CELL value < 250000 then answer = 1% of CELL value If CELL value =250000 and <500000 then answer = 3% of CELL value If CELL value 500000 then answer = 4% of CELL value In the above example where CELL = 310000 the answer should be 9300 Thanks for your help |
Stamp Duty
Thanks very much - your formula is correct.
"Toppers" wrote: Try: =IF(A1<250000,A1*0.01,IF(A1<=500000,A1*0.03,A1*0.0 4)) I assumed <= 500000 ss it wasn't clear from your posting HTH "Mr Stanley (UK)" wrote: I am trying to write a formula to calculate the stamp duty in the UK as follows for Excel 2000. Below CELL is the value of the property purchased i.e £310000 If CELL value < 250000 then answer = 1% of CELL value If CELL value =250000 and <500000 then answer = 3% of CELL value If CELL value 500000 then answer = 4% of CELL value In the above example where CELL = 310000 the answer should be 9300 Thanks for your help |
Stamp Duty
Thanks Ardus - there is an error in your formula. See Toppers reply.
Thank you anyway for your reply. "Ardus Petus" wrote: Say CELL is A1 =A1*IF(A1<250000,0.01,IF(A1<50000,0.03,0.04)) HTH -- AP "Mr Stanley (UK)" <Mr Stanley a écrit dans le message de news: ... I am trying to write a formula to calculate the stamp duty in the UK as follows for Excel 2000. Below CELL is the value of the property purchased i.e £310000 If CELL value < 250000 then answer = 1% of CELL value If CELL value =250000 and <500000 then answer = 3% of CELL value If CELL value 500000 then answer = 4% of CELL value In the above example where CELL = 310000 the answer should be 9300 Thanks for your help |
All times are GMT +1. The time now is 02:13 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com