Round Up in Excel 1

[ICCIIT]

I have a problem with excel 97, I am trying to round up as follows:-

If the result is between 0-49 then show 50
If the result is between 50-99 then show 00

i.e 201 would show 250 and 251 would show 300

Can anybody, help I have tried roundup but this only does the decimal place?

Thanks

 

[AnotherHiggins]

FYI: RoundUp can do more than decimal places - just use a negative number e.g. =RoundUp(A1,-2)

But what you want in this case is
[COLOR=blue white]=CEILING(A1,50)[/color]

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.