Hi there,
I am new to access and I am trying to build a calculator for when I am buying a buy to let property. I am trying to find the query for second property Stamp duty and failing miserably at every turn.
I have found one for excel but it make no sense to me at all and do no have a clue on how to translate it into access even if it is possible.
this is what it looks like in excel:
=SUMPRODUCT(--(B4>{125000;250000;925000;1500000}), (B4-{125000;250000;925000;1500000}), {0.02;0.03;0.05;0.02})+(B4*IF(B4>39999,0.03,0))
If you are good enough to answer or help please be gentle as I really do not have a clue and I am in at the deep end with little knowledge and understanding of terminology. Thank you in advance
I am new to access and I am trying to build a calculator for when I am buying a buy to let property. I am trying to find the query for second property Stamp duty and failing miserably at every turn.
I have found one for excel but it make no sense to me at all and do no have a clue on how to translate it into access even if it is possible.
this is what it looks like in excel:
=SUMPRODUCT(--(B4>{125000;250000;925000;1500000}), (B4-{125000;250000;925000;1500000}), {0.02;0.03;0.05;0.02})+(B4*IF(B4>39999,0.03,0))
If you are good enough to answer or help please be gentle as I really do not have a clue and I am in at the deep end with little knowledge and understanding of terminology. Thank you in advance