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 NewITZone Your Own Question
NewITZone, Computer Enthusiast
Category: Microsoft Office
Satisfied Customers: 90
Experience:  I have been using Office Pro for 10 years and implemented applications for business use.
Type Your Microsoft Office Question Here...
NewITZone is online now
A new question is answered every 9 seconds

I am using Excel. I am having a problem in adding a column

Customer Question

I am using Excel. I am having a problem in adding a column of numbers that have been calculated by using percentages. When adding the numbers, I get a difference of 1 dollar. Perhaps there is hiding value in excel when using percentages but my totals are off . Any suggestionsI
Submitted: 12 months ago.
Category: Microsoft Office
Expert:  KarenLynneJ replied 12 months ago.

Welcome to JustAnswer! My name is ***** ***** I am reviewing your question now. I will respond shortly!

Expert:  KarenLynneJ replied 12 months ago.

Hi -

If you right click on a cell with a percentage, select Format Cells and then percentage, what is the decimal place set to?

Customer: replied 12 months ago.
Expert:  KarenLynneJ replied 12 months ago.

Can you send me the formula used to calculate the numbers? (i.e. Cell A = 100 Cell B = 5% Calculated number = A*B)

Customer: replied 12 months ago.
L18 is a percentage total
Expert:  KarenLynneJ replied 12 months ago.

Sorry this request is not a financial software question - I am asking moderators to move to the Microsoft Office category. I am going to opt out.

Expert:  Richard replied 12 months ago.

Hi there and welcome

Please attach the spreadsheet to this question and I will look at it for you.