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! |
=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! |
All times are GMT +1. The time now is 04:32 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com