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

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!

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

On Wed, 26 Jan 2005 13:35:09 -0800, "vnsrod2000"
wrote:

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!