Stamp Duty

[Mr Stanley (UK)]

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

[Toppers]

Try:

=IF(A1<250000,A1*0.01,IF(A1<=500000,A1*0.03,A1*0.04))

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

[Ardus Petus]

Say CELL is A1

=A1*IF(A1<250000,0.01,IF(A1<50000,0.03,0.04))

HTH
--
AP

"Mr Stanley (UK)" <Mr Stanley (UK)@discussions.microsoft.com> a écrit dans
le message de news: [email protected]...
>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

[Mr Stanley (UK)]

Thanks very much - your formula is correct.

"Toppers" wrote:

> Try:
>
> =IF(A1<250000,A1*0.01,IF(A1<=500000,A1*0.03,A1*0.04))
>
> 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

[Mr Stanley (UK)]

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 (UK)@discussions.microsoft.com> a écrit dans
> le message de news: [email protected]...
> >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
>
>
>