=j49*1.175


--

Regards,

Peo Sjoblom

"jsansom" wrote in
message ...

Hello all,

im really stuck on working out the formula to add 17.5% vat to my job
sheet.
I have this formula for the last cell (J49) which i would like to have
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 and
taking away the J47 for any discount but how do i make it add 17.5% vat
to the J49 cell which is my total inc vat figure which at the moment
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
Jeremy


--
jsansom
------------------------------------------------------------------------
jsansom's Profile:
http://www.excelforum.com/member.php...o&userid=28754
View this thread: http://www.excelforum.com/showthread...hreadid=484426