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. I think the problem is I dont know how to write the "but" correctly
Thanks a lot.
Bookmarks