how to add 17.5% vat formula

  • Thread starter Thread starter jsansom
  • Start date Start date
J

jsansom

Hello all,

im really stuck on working out the formula to add 17.5% vat to my jo
sheet.
I have this formula for the last cell (J49) which i would like to hav
add the vat to this is the formula at the moment in cell J49
=J45+J46+J48-J47 these cells add up my entries for parts ordered an
taking away the J47 for any discount but how do i make it add 17.5% va
to the J49 cell which is my total inc vat figure which at the momen
just says as the total not including the VAT...
Sorry if that sounds confusing but i am a real novice LOL

Thanks in advance for any help you can give me.

Regards
Jerem
 
J 49 looks like this =J45+J46+J48-J47

If i add =j49*1.175 to the end so i get =J45+J46+J48-J47=j49*1.175 or
even remove the = to this =J45+J46+J48-J47=j49*1.175 neither work?

Im being dumb arnt i?? sorry to ask but exactley what do i need to put
in on my cell J49 which at the moment is reading =J45+J46+J48-J47


or maybe i could send the sheet so you can see what im doing wrong?

Regards

Jeremy

P.s thanks for responding
 
Hi Jeremy

Peo's answer is perfectly correct for the question you posed.
However, what is more useful and acceptable for the recipient of your
invoice is to show the VAT separately.
So maybe in J50 =J49*.175
and in J51 =J49+J50

Just a thought.

Regards

Roger Govier
 
If you really must have it in *one* cell, try this in J49:

=SUM(J45,J46,J48,-J47)*1.175

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
 
Back
Top