Rounding up with other formulas in cell

[tara_922]

Total Req...................Total Requests Statistics
T&T 371...........T&T 74%
MW / FC 128...........MW/FC 26%
RCI 3..............RCI 1%
PR 3..............PR 1%
PAID FEE 1..............PAID Fee 0%
GST SAT 22............GST SAT 4%
G 44............G 9%
P 52............P 10%
Rentals 374...........Rentals 75%

Total Req 499...........Total Req 100%


Total Service...............Total Service Stats
T&T 289............T&T 58%
MW / FC 97..............MW/FC 19%
RCI 3...............RCI 1%
PR 2...............PR 0%
PAID FEE 1...............PAID Fee 0%
GST SAT 15.............GST SAT 3%
G 34.............G 7%
P 40.............P 8%
Rentals 289...........Rentals 58%

Total S 386 77%


Total Non-Service.........Total Non-Service Stats
T&T 82..............T&T 16%
MW / FC 31..............MW/FC 6%
RCI 0................RCI 0%
PR 1................PR 0%
PAID FEE 0................PAID Fee 0%
GST SAT 6................GST SAT 1%
G 9................G 2%
P 11..............P 2%
Rentals 82..............Rentals 16%

Total N/S 113 23%


Okay, so there is the data. The problem I'm having is that the Total Non-Service PR = 1. I divide that by the Total Req of 499 = .002 Ideally the columns in the % Non-Service from RCI to Rentals would equal T&T plus MW/FC because from RCI-Rentals is the breakdown of T&T and MW/FC

How do I round (to the nearest 1%) these numbers up whilst also having the division formula in the cell to calculate the percentage?

Thanks for your help!

Tara

P.S. Sorry the numbers are all screwy, it wouldn't save my format...

 

[tara_922]

=B39/$B$12

That's my simple formula but I want to calcuate to the nearest 1%.

Any ideas at all??

Tara

 

[VoG]

Maybe

=ROUND(B39/$B$12,2)

 

[tara_922]

perfect! I altered it a little to roundup but it worked fabulously! Thanks so much!

Tara