Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
#6
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|