Rounding nearest Integer value for Max value

[grajmca_sgp123]

Hi ,

RangeMax(22.9,250,100) --->i will get the 250

If i use Ceil fun or round fun also i will get same results.

But my requirement is I want to get 300 which is nearest value for max value.How can we achieve.

[sunny_talwar]

Try this:

=Ceil(250, 100)

[sunny_talwar]

Or this:

=Ceil(RangeMax(22.9,250,100), 100)

[senpradip007]

You can use round(RangeMax(22.9,250,100), 100) also.