How can i round off .10 as .50 and .51 as 1.00
 

Dear Concerned,

Please advise how can i round off .10 as .50 and .51 as 1.00 ? The summary
is that how can i round off the figures in a round off of .50.

Waiting for a favourable response from your end.

Regards
Santosh Budalakoti

Hi
=Ceilin(A1,0.5)

Also see:
http://www.xldynamic.com/source/xld.Rounding.html

--
Regards
Frank Kabel
Frankfurt, Germany

Santosh Budalakoti wrote:
Dear Concerned,

Please advise how can i round off .10 as .50 and .51 as 1.00 ? The
summary is that how can i round off the figures in a round off of .50.

Waiting for a favourable response from your end.

Regards
Santosh Budalakoti

oops Frank,

=Ceiling(A1,0.5)

Bob

"Frank Kabel" wrote in message
...
Hi
=Ceilin(A1,0.5)

Also see:
http://www.xldynamic.com/source/xld.Rounding.html

--
Regards
Frank Kabel
Frankfurt, Germany

Santosh Budalakoti wrote:
Dear Concerned,

Please advise how can i round off .10 as .50 and .51 as 1.00 ? The
summary is that how can i round off the figures in a round off of .50.

Waiting for a favourable response from your end.

Regards
Santosh Budalakoti

thanks :-)

--
Regards
Frank Kabel
Frankfurt, Germany

Bob Phillips wrote:
oops Frank,

=Ceiling(A1,0.5)

Bob

"Frank Kabel" wrote in message
...
Hi
=Ceilin(A1,0.5)

Also see:
http://www.xldynamic.com/source/xld.Rounding.html

--
Regards
Frank Kabel
Frankfurt, Germany

Santosh Budalakoti wrote:
Dear Concerned,

Please advise how can i round off .10 as .50 and .51 as 1.00 ? The
summary is that how can i round off the figures in a round off of
.50.

Waiting for a favourable response from your end.

Regards
Santosh Budalakoti

Hi Frank,

It's what we are here for. Did you see Jamie's catch of my answer on
initiating classes? Helps my old memory :-)

Bob


"Frank Kabel" wrote in message
...
thanks :-)

--
Regards
Frank Kabel
Frankfurt, Germany

Bob Phillips wrote:
oops Frank,

=Ceiling(A1,0.5)

Bob

"Frank Kabel" wrote in message
...
Hi
=Ceilin(A1,0.5)

Also see:
http://www.xldynamic.com/source/xld.Rounding.html

--
Regards
Frank Kabel
Frankfurt, Germany

Santosh Budalakoti wrote:
Dear Concerned,

Please advise how can i round off .10 as .50 and .51 as 1.00 ? The
summary is that how can i round off the figures in a round off of
.50.

Waiting for a favourable response from your end.

Regards
Santosh Budalakoti

Hi Bob
saw it. Jamie is really good on this class stuff :-)
Frank

--
Regards
Frank Kabel
Frankfurt, Germany

Bob Phillips wrote:
Hi Frank,

It's what we are here for. Did you see Jamie's catch of my answer on
initiating classes? Helps my old memory :-)

Bob


"Frank Kabel" wrote in message
...
thanks :-)

--
Regards
Frank Kabel
Frankfurt, Germany

Bob Phillips wrote:
oops Frank,

=Ceiling(A1,0.5)

Bob

"Frank Kabel" wrote in message
...
Hi
=Ceilin(A1,0.5)

Also see:
http://www.xldynamic.com/source/xld.Rounding.html

--
Regards
Frank Kabel
Frankfurt, Germany

Santosh Budalakoti wrote:
Dear Concerned,

Please advise how can i round off .10 as .50 and .51 as 1.00 ? The
summary is that how can i round off the figures in a round off of
.50.

Waiting for a favourable response from your end.

Regards
Santosh Budalakoti