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

=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

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


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

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


Peo Sjoblom wrote:
=j49*1.175

Use parenthesis.

=(J45+J46+J48-J47=j49)*1.175

Regards,
Paul

"jsansom" wrote in
message ...

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


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

Ooops. Do it this way.

=(J45+J46+J48-J47)*1.175


"PCLIVE" wrote in message
...
Use parenthesis.

=(J45+J46+J48-J47=j49)*1.175

Regards,
Paul

"jsansom" wrote in
message ...

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


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

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!
==============================================


"jsansom" wrote in
message ...

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


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

Thanks all,

Done it now thanks to your help

Have a good weekend

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