$$Excel-Macros$$ Re: Round figure

ay, January 22, 2009 11:59:34 PMSubject: $$Excel-Macros$$ Re: Round figure Thanks to every one who help me on below issue though every one has the unique way that realy add my knowledge. Mr Paul thanks a lot your solution absolutely solve my problem .Allah Hafiz ,Kamran Haider . Date: Thu,

$$Excel-Macros$$ Re: Round figure

andard rounding functions. It's actually a basic rounding problem that I encountered in a FORTRAN class 30 years ago! Some truths are forever! good luck, Paul From: Kamran Haider To: vba Sent: Thursday, January 22, 2009 11:59:34 PM Subject: $$Excel-Macro

$$Excel-Macros$$ Re: Round figure

Thanks to every one who help me on below issue though every one has the unique way that realy add my knowledge. Mr Paul thanks a lot your solution absolutely solve my problem .Allah Hafiz ,Kamran Haider . Date: Thu, 22 Jan 2009 05:41:36 -0800From: schreiner_p...@att.netsubject: $$Excel-Ma

$$Excel-Macros$$ Re: Round figure

That's was good common sense... I really really appreciate Regards, Sarfaraz Ahmed MS Excel help On Thu, Jan 22, 2009 at 7:11 PM, Paul Schreiner wrote: > You should be able to use: > =ROUND(A1-0.3,0) > Paul > > -- > *From:* Kamran Ha

$$Excel-Macros$$ Re: Round figure

Consider using the ROUND, ROUNDUP or ROUNDDOWN functions On Thu, Jan 22, 2009 at 4:36 AM, Kamran Haider wrote: > Dear Group mates, > > Please help me on round formula as xl built in formula round the figure on > general math rule i.e 25.5 to 26 and 25.4 > to 25 whereas i want to work this form

$$Excel-Macros$$ Re: Round figure

Your question is confusing. Are you sure wht you want to do. However, mentioned below are few suggestions which you can follow and whatever suites you best 24.79 round(24.79,0) will return 25 if you want it to return you the lowest integer before 24.79 then use INT(24.79) which will return 2

$$Excel-Macros$$ Re: Round figure

You should be able to use: =ROUND(A1-0.3,0) Paul From: Kamran Haider To: vba Sent: Thursday, January 22, 2009 4:36:11 AM Subject: $$Excel-Macros$$ Round figure Dear Group mates,   Please help me on round formula as xl built in formula round the figure on gene