Quote:
| Originally Posted by colinicky this is what I'm after  ATM my mother would enter the total, then the basic amount & then the vat element all by hand & working out each bit with a calculator !
Because most of our things are fixed price the ideal for me would be a formula that gave this :-
If Column A = "ground rent " then column B = £2000 ,then Column C= (column B /117.5*100),then Column D = (column B/117.5*17.5 )
If you see what I mean ? but how the hell do you write a formula for that !  |
H5 is the triger which is a 1 or a 0 for three diferent VAT settings id need
H, I and J and to put a 1 in the relevent column
Then you will need three VAT columns each with a letter asociated H I or J
If H = 0 coloumn 1 =0.00
If I = 0 coloumn 2 = 0.00
If J =1 then coloumn 3 = VAT at what ever rate you set it.
My coloums are set to things like car, office wages, tools, phone etc etc. They start at L and go up to coloumn U
So my system takes what vere numbers apear on that row and do the math bassed on a 1 being in box H
=SUM(L5:U5)*17.5%*H5
Ill send you a months accounts to play with
ATB
Mark