Rounding

[matt]

I have an excel sheet with the following:
A B
150
25
200

In B I want it to round to the nearest 100, but I do not
want 0 to appear in column B like it would return for 25.
I want a minimum of 100. Any ideas?

 

[JulieD]

Hi Matt

one idea

=IF(A1>100,ROUND(A1,-2),A1)

cheers
JuileD

 

[Domenic]

Hi Matt,

Try,

=MAX(ROUND(A1,-2),100)

Hope this helps!

 

[Lady Layla]

To return 100 if the cell is less than 100, would need to have

=IF(A1>100,ROUND(A1, -2),100)


Julie's formula would return A1 as the answer ... ie would return 25



: Hi Matt
:
: one idea
:
: =IF(A1>100,ROUND(A1,-2),A1)
:
: cheers
: JuileD
:
: : > I have an excel sheet with the following:
: > A B
: > 150
: > 25
: > 200
: >
: > In B I want it to round to the nearest 100, but I do not
: > want 0 to appear in column B like it would return for 25.
: > I want a minimum of 100. Any ideas?
:
:

 

[JE McGimpsey]

One way:

=MAX(100,ROUND(A1,-2))

 

[JulieD]

sorry i misunderstood the question (maybe) i thought the OP wanted to show
the number if less than 100 and only round over 100 ...