=ROUND(((C22*G11)*G17),2)
rounds that formula to the nearest penny.
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Chandra" wrote in message
...
I'm working in a spreasheet that has a lot of formulas, if I want to round
the number that a formula shows, do I need to do that in a different colmn
or
is there something I can add to the formula to round it to the nearest
dollar? Here is an example if the formula I'm often using in this
spreadsheet.
=((C22*G11)*G17)
|