How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask AAATom Your Own Question

AAATom
AAATom, Computer Software Engineer
Category: Programming
Satisfied Customers: 468
Experience:  20+ years of experience in embedded programming (assembly, C), Windows programming (VB, user interface design)
66411959
Type Your Programming Question Here...
AAATom is online now

I need to l setup excel for my invoicing to show totals as

Customer Question

I need to l setup excel for my invoicing to show totals as exsample

invoice total £100.00
VAT £20.00
total inc VAT £120.00

I do not know how to do % so that they show automatically can you please help
Submitted: 2 years ago.
Category: Programming
Expert:  AAATom replied 2 years ago.

AAATom :

Hello and welcome to JustAnswer!

I would like to help you get the invoicing show correct values.

Can you, please, tell me do you actually need help with a formula or would you like me to fix/correct your Excel spreadsheet?

Thank you,
Tom

AAATom :

I can do both, just need to know which of the two would you like me to do.

Customer:

need help help with formula

AAATom :

OK, thank you.

AAATom :

You have to set the cell number format to percentage first.

AAATom :

Then the formula for VAT would be:
=C9*0,8

AAATom :

where C9 is the cell with 100 pound total.

AAATom :

The total including VAT would be:

AAATom :

=C9*1,2

AAATom :

or you can sum the total and VAT

AAATom :

=C9+C10

AAATom :

where C10 is the cell with =C9*0,8

AAATom :

It sounds complicated this way, let me prepare an example.

AAATom :

Oh, sorry, I made a mistake

AAATom :

it should be:
=C9*0,2

AAATom :

Please have a look at the example:




































Article 1£20,00
Artice 2£40,00
Artice 3£30,00
Article 4£10,00
Total£100,00=SUM(C5:C8)
VAT£20,00=C9*0,2
Total inc. VAT£120,00=C9+C10
AAATom :

The formulas to the right of numbers are what should go into the cells instead of the numbers.

AAATom :

Disregard my previous comment about Number Formatting.

Customer:

just what i need many thanks will try it tomorrow have had

AAATom :

You are welcome!

AAATom :

I am glad I could help!

AAATom, Computer Software Engineer
Category: Programming
Satisfied Customers: 468
Experience: 20+ years of experience in embedded programming (assembly, C), Windows programming (VB, user interface design)
AAATom and 2 other Programming Specialists are ready to help you
Expert:  AAATom replied 2 years ago.
Thank you for excellent rating and bonus, Graham!
I appreciate it very much!
Customer: replied 2 years ago.

I is not working please help

Expert:  AAATom replied 2 years ago.
Hello Graham,

I am sorry you have problems with it.

Please download this Excel workbook with the example:
http://ge.tt/api/1/files/5GoolGh1/0/blob?download


The formula for VAT you look for is in cell C10.

Let me know if you face any difficulties.

Tom

What Customers are Saying:

 
 
 
  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer
< Previous | Next >
  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C.
  • This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!! Alex
  • Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult. GP
  • I couldn't be more satisfied! This is the site I will always come to when I need a second opinion. Justin
  • Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around. Esther
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C.
 
 
 

Meet The Experts:

 
 
 
  • ATLPROG

    ATLPROG

    Computer Software Engineer

    Satisfied Customers:

    7260
    MS in IT.Several years of programming experience in Java C++ C C# Python VB Javascript HTML
< Previous | Next >
  • http://ww2.justanswer.com/uploads/SP/spatlanta2010/2011-6-23_12450_photo.64x64.gif ATLPROG's Avatar

    ATLPROG

    Computer Software Engineer

    Satisfied Customers:

    7260
    MS in IT.Several years of programming experience in Java C++ C C# Python VB Javascript HTML
  • http://ww2.justanswer.com/uploads/ComputersGuru/2010-02-13_051118_Photo41.JPG LogicPro's Avatar

    LogicPro

    Computer Software Engineer

    Satisfied Customers:

    5514
    Expert in C, C++, Java, DOT NET, Python, HTML, Javascript, Design.
  • http://ww2.justanswer.com/uploads/lifesaver333/2010-10-17_191349_ls.jpeg lifesaver's Avatar

    lifesaver

    Computer Software Engineer

    Satisfied Customers:

    936
    Several years of intensive programming and application development experience in various platforms.
  • http://ww2.justanswer.com/uploads/EH/ehabtutor/2012-8-2_202016_1.64x64.jpg ehabtutor's Avatar

    ehabtutor

    Computer Software Engineer

    Satisfied Customers:

    766
    Bachelor of computer science, 5+ years experience in software development, software company owner
  • http://ww2.justanswer.com/uploads/eljonis/2010-01-06_130406_eljon2.jpg Eljon's Avatar

    Eljon

    Consultant

    Satisfied Customers:

    558
    Founder of StockCanvas.com
  • http://ww2.justanswer.com/uploads/FA/fael/2011-1-15_104041_profile500x500.64x64.jpg Rafael Martins's Avatar

    Rafael Martins

    Computer Software Engineer

    Satisfied Customers:

    446
    Desktop, Mobile and Web Developer. 7+ years of experience. Creative solutions provider.
  • http://ww2.justanswer.com/uploads/CH/chutz747/2011-11-6_14231_me.64x64.jpg The-PC-Guy's Avatar

    The-PC-Guy

    Software Engineer

    Satisfied Customers:

    320
    Extensive Knowledge in PHP, MYSQL, CSS & Javascript