decimal correction
 

Sirs,
When a number with decimals is corrected to a required number of decimal
places,the multiplication of that number is giving incorrect
value(considering the decimal number prior to correction).Kindly advise any
method to rectify this?
Thanking you,
K.S.Warrier

Hi
formatting alone does not help :-)
Use something like
=ROUND(A1,2)

--
Regards
Frank Kabel
Frankfurt, Germany

"K.S.Warrier" schrieb im
Newsbeitrag ...
Sirs,
When a number with decimals is corrected to a required number of
decimal
places,the multiplication of that number is giving incorrect
value(considering the decimal number prior to correction).Kindly
advise any
method to rectify this?
Thanking you,
K.S.Warrier

Hi,
Thank you for your immediate response.
Regards,
K.S.Warrier

"Frank Kabel" wrote:

Hi
formatting alone does not help :-)
Use something like
=ROUND(A1,2)

--
Regards
Frank Kabel
Frankfurt, Germany

"K.S.Warrier" schrieb im
Newsbeitrag ...
Sirs,
When a number with decimals is corrected to a required number of
decimal
places,the multiplication of that number is giving incorrect
value(considering the decimal number prior to correction).Kindly
advise any
method to rectify this?
Thanking you,
K.S.Warrier