Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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! |
#2
![]() |
|||
|
|||
![]()
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
Amount or Numbers in Words | New Users to Excel | |||
Is there a formula to spell out a number in excel? | Excel Worksheet Functions | |||
Convert Numeric into Text | Excel Worksheet Functions | |||
Spellnumber | Excel Worksheet Functions |