• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 191
  • Last Modified:

How can we do in Excel 2007 a calculation with 2 percentage cell and return the correct result

We need to calculate various percentage cell and the result placed in a another percentage cell.

      For example

      A1 = 20%

      A2 = 100-A1

      The result returns 9980% instead of 80%

How can we do this?
(the cell is formatted as percentage)
0
rayluvs
Asked:
rayluvs
  • 2
1 Solution
 
Juan OcasioCommented:
Put a percent sign after the 100

 A1 = 20%

 A2 = 100%-A1

0
 
rayluvsAuthor Commented:
yeah worked!
0
 
rayluvsAuthor Commented:
thanx
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now