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

V

vnsrod2000

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

Myrna Larson

Assuming the result of the 1st calculation is in B2, the 2nd formula should be

=ROUND(B2,2)*1500

Or, if you write

=ROUND(35/40,2) in cell B2, the 2nd formula is =B2*1500
 

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 8
Calculate the median value before a specified list 0
Calculating Sum - when numbers are rounded... 2
Lookup value with multipe Results 5
Nested if using range names 1
Timesheet in and out rounding 3
Excel 2002 Analysis ToolPak Regression Analysis Help Requested 1
How do I round a formula result to the next integer? 8

Top