Formula Help
in [General]
|
From: Jackie Morin Jackie on 2 Feb 2010 16:07 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.
From: Don on 2 Feb 2010 16:12 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.
From: "David Biddulph" groups [at] on 2 Feb 2010 16:13 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.
|
Pages: 1 Prev: Hard to select first worksheet tab Next: Nonadjacent columns |