| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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! |
|
#2
|
|||
|
|||
|
=ROUNDUP(35/40,2)
"vnsrod2000" wrote in message ... 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 | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Put the result of the calculation between 2 columns in a new works | Excel Discussion (Misc queries) | |||
| 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 | |||
Linear Mode
