heyzeus

2011-09-27, 06:56 PM

Hi guys,

This is a pretty simple formula question, but I can't find the answer anywhere (im probably not searching for the correct key words).

Im trying to write a formular to work out VAT rates.

Say A1=Date, B1=Amount, and C1=VAT rate. The formular will be written into C1, and needs to apply the following rules;

If A1<01/12/08,B1*0.175

If A1>01/12/08, but<01/10/10, B1*0.15

If A1>01/01/10, but <04/01/10, B1*0.175

If A1> 04/01/11, B1*0.20

I hope this makes sense. I have tried linking the various rules a number of ways but can't find the soloution. It allways seems to give cummaltive VAT rate (so something like .17.5 + .15 say or gives a 0).

Thanks a lot.

This is a pretty simple formula question, but I can't find the answer anywhere (im probably not searching for the correct key words).

Im trying to write a formular to work out VAT rates.

Say A1=Date, B1=Amount, and C1=VAT rate. The formular will be written into C1, and needs to apply the following rules;

If A1<01/12/08,B1*0.175

If A1>01/12/08, but<01/10/10, B1*0.15

If A1>01/01/10, but <04/01/10, B1*0.175

If A1> 04/01/11, B1*0.20

I hope this makes sense. I have tried linking the various rules a number of ways but can't find the soloution. It allways seems to give cummaltive VAT rate (so something like .17.5 + .15 say or gives a 0).

Thanks a lot.