| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Please help with enclosed schedule of duty | Excel Worksheet Functions | |||
| date/time stamp | Excel Worksheet Functions | |||
| Time stamp in Excel Sheet | Excel Discussion (Misc queries) | |||
| bringing data from one workbook to another using a date stamp func | Excel Worksheet Functions | |||
| Time Stamp without change | Excel Discussion (Misc queries) | |||
Linear Mode
