Rounding

[SDBonner]

Hi there,

Is there a way of having ROUNDUP activated if the amount is =>500 and ROUNDDOWN if =<499 WITHIN a larger number, and within the same cell e.g.

if amount = 2,369 result will be 2,000
if amount = 2,698 result will be 3,000

Was thinking about an IF but unsure about how to express the greater than or less than bits.

As always, much thanks in advance and happy to give further clarification if required.

S.

 

[dazfoz]

=round(A1,-3)

Should do the trick

 

[Ron99]

Hi,

I suppose round, roundup and roundown works only if there is a decimal, not otherwise.

you can work with this formula, assuming the numbers are in A1 AND A2

=IF(AND(A1>=2500,A1<3000),3000,2000)

 

[dazfoz]

Ron,

Using the decimal position of -1 (Single), -2 (Tens), -3(hundreds) etc works just as well doesnt it?

Your formulea works great for between 2000 & 3000, but I think the OP was looking for <=> 500 for any number.

Regards

 

[sanrv1f]

Hi Ron99,

Did you test dazfoz formula? it does work