Rounding

M

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?
 
L

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?
:
:
 
J

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 ...
 
Top