Round in excel 97
I have the situation where a few colleagues are on Excel 97 (don't ask!) and a procedure
is blocking at the following statement for Round. Can anyone help me with an alternative statement to this. I would value any guidance. If Round(TotA, 2) < Round(TotB, 2) Then Kind Regards, Graham Turriff Scotland |
Round in excel 97
The Round function was introduced in xl2000 for VBA. For xl97, you can use the worksheet Round function... If Application.Round(TotA, 2) < Application.Round(TotB, 2) Then I think that you will find that xl97 is faster and easier to use than the latest super whiz-bang Excel version. -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "Graham" wrote in message I have the situation where a few colleagues are on Excel 97 (don't ask!) and a procedure is blocking at the following statement for Round. Can anyone help me with an alternative statement to this. I would value any guidance. If Round(TotA, 2) < Round(TotB, 2) Then Kind Regards, Graham Turriff Scotland |
Round in excel 97
Jim,
You are an abolute star! Many thanks for that. Graham Jim Cone wrote: The Round function was introduced in xl2000 for VBA. For xl97, you can use the worksheet Round function... If Application.Round(TotA, 2) < Application.Round(TotB, 2) Then I think that you will find that xl97 is faster and easier to use than the latest super whiz-bang Excel version. |
Round in excel 97
Hi Jim,
Let me get this right, for performance and usability you are suggesting people might consider upgrading from Excel 2007 to Excel 97. :-) Regards, Peter T "Jim Cone" wrote in message ... The Round function was introduced in xl2000 for VBA. For xl97, you can use the worksheet Round function... If Application.Round(TotA, 2) < Application.Round(TotB, 2) Then I think that you will find that xl97 is faster and easier to use than the latest super whiz-bang Excel version. -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "Graham" wrote in message I have the situation where a few colleagues are on Excel 97 (don't ask!) and a procedure is blocking at the following statement for Round. Can anyone help me with an alternative statement to this. I would value any guidance. If Round(TotA, 2) < Round(TotB, 2) Then Kind Regards, Graham Turriff Scotland |
Round in excel 97
Hello Peter, Absolutely! (Service Release 2) <g -- Regards, Jim Cone "Peter T" wrote in message Hi Jim, Let me get this right, for performance and usability you are suggesting people might consider upgrading from Excel 2007 to Excel 97. :-) Regards, Peter T "Jim Cone" wrote in message The Round function was introduced in xl2000 for VBA. For xl97, you can use the worksheet Round function... If Application.Round(TotA, 2) < Application.Round(TotB, 2) Then I think that you will find that xl97 is faster and easier to use than the latest super whiz-bang Excel version. -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "Graham" wrote in message I have the situation where a few colleagues are on Excel 97 (don't ask!) and a procedure is blocking at the following statement for Round. Can anyone help me with an alternative statement to this. I would value any guidance. If Round(TotA, 2) < Round(TotB, 2) Then Kind Regards, Graham Turriff Scotland |
All times are GMT +1. The time now is 03:26 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com