Hi every one,
Ive been glued to this forum for seval hours now, reading older posts, but Im going to admit defeat before my brain explodes!!
OK so Im a novice with excel, but I dont want to be beaten!
Also before answering, can you help me by just keeping it simple, and basing it on 100-20% vat ?
eg: click 100, type *-20 etc etc I think its all the a1/d5 ()... etc thats done me![Laugh :LOL: :LOL:](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
SO doing my VAT....
Ive got a formular to MINUS the vat (just descovering that subtracting 20% VAT rather than 20% is not the same thing)
THIS is my Minus formular for 100 – 20% vat = 16.67
click destination cell, type = . click 100, type *-1/6% > hit return. = 16.67
Now on the flip side, to work out 20% vat of 100, Ive currently got:
Click destination cell, type = > click 100, type *20% > hit return = 20
Im also checking this is an online VAT calculator the figures seem to be right , but is the formular correct???
Many Many Thanks for the answers in advance, I cant tell you how much help will be appriciated! x
![Stick out tongue :p :p](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
Ive been glued to this forum for seval hours now, reading older posts, but Im going to admit defeat before my brain explodes!!
OK so Im a novice with excel, but I dont want to be beaten!
Also before answering, can you help me by just keeping it simple, and basing it on 100-20% vat ?
eg: click 100, type *-20 etc etc I think its all the a1/d5 ()... etc thats done me
SO doing my VAT....
Ive got a formular to MINUS the vat (just descovering that subtracting 20% VAT rather than 20% is not the same thing)
THIS is my Minus formular for 100 – 20% vat = 16.67
click destination cell, type = . click 100, type *-1/6% > hit return. = 16.67
Now on the flip side, to work out 20% vat of 100, Ive currently got:
Click destination cell, type = > click 100, type *20% > hit return = 20
Im also checking this is an online VAT calculator the figures seem to be right , but is the formular correct???
Many Many Thanks for the answers in advance, I cant tell you how much help will be appriciated! x