Thread
:
Formula problem with decimal
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Sandy Mann
external usenet poster
Posts: 2,345
Formula problem with decimal
Round the Multiplication like:
=ROUND(Cell1*Cell2,2)
--
HTH
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
Replace @mailinator.com with @tiscali.co.uk
"Gator" wrote in message
...
I am multiplying two cells to get a result in a third cell. the result
comes
out to be 18.525. I format the decimal to show only two numbers, like
18.53
but when I multiply this number to another number it is multiplying like
18.525. How can I make it multiply like 18.53?
thanks
Reply With Quote
Sandy Mann
View Public Profile
Find all posts by Sandy Mann