Spreadsheet

[Guest]

In excel I am using a spreadsheet, putting figures in ie Sub Total-
VAT-Total, how do I set it up to automatically insert the VAT, after I have
entered the Total the VAT and Sub total should be entered through the correct
set up. What is this???? Help

 

[Bernie Deitrick]

Scarlet,

If you have a total (subtotal + VAT), then the VAT is

=TOTAL*(VATRate)/(1+VATRate)

where VATRate is in percent or decimal (17.5% or 0.175)

and the Sub-Total is

=TOTAL/(1+VATRate)

HTH,
Bernie
MS Excel MVP