• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

Excel Question-How to set an resolution for a number range?

VashHT

VashHT

Diamond Member
I am trying to format a number range so that it has a set resolution-say.005. I am having trouble finding anything like that in the format number guides I have been looking up, does anyone know how to do this?
 
I'm not at my PC but this should be doable with the round function if I'm not mistaken

Edit:
Yep this should do it
=ROUND(A1/0.005,0)*0.005

Found it here: http://www.mrexcel.com/forum/excel-questions/45283-rounding-decimals.html
 
Last edited:
You must log in or register to reply here.

TRENDING THREADS

Back
Top