How do I use a rounded calculation result in another calculation?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Calculation A
I am finding a percent score, but I want it rounded to the nearest percent.
For example, I want the following result to display as 88%:
(35/40)=87.5%

I know the result is displayed as 88%, but I want to use the actual rounded
result (88%) in Calculation B.

Calculation B
What I want is .88*1500=1320
What I get is .88*1500=1313
Help!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculating Future Value 6
Help on percentages greater than 100 3
Help generating score from finishing position 7
time calculation 7
descending order of a series of data 8
Calculating Sum - when numbers are rounded... 2
Rounding the result of two times 3
Excel Excel 2007 won't stop rounding down my formula results! 5

Back
Top