ExcelBanter - Formula Help

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Formula Help (https://www.excelbanter.com/excel-discussion-misc-queries/255133-formula-help.html)

Jackie Morin

Formula Help

How do I enter a formula to look at a number and based on calculation round
up or down to nearest hundreth? For example 421 would round down to 400 while
573 would round up to 600.

Don

Formula Help

try =round(a1,-2) where A1 has the number you want to round to the 100's

"Jackie Morin" wrote:

How do I enter a formula to look at a number and based on calculation round
up or down to nearest hundreth? For example 421 would round down to 400 while
573 would round up to 600.

David Biddulph[_2_]

Formula Help

You could look up ROUND in Excel help.
Try =ROUND(A2,-2)
--
David Biddulph

Jackie Morin wrote:
How do I enter a formula to look at a number and based on calculation
round up or down to nearest hundreth? For example 421 would round
down to 400 while 573 would round up to 600.

All times are GMT +1. The time now is 06:53 PM.