View Single Post
  #3   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

There is no need to have those extra parenthesis unless there are other
types of calculations involved (like addition), to round that to the nearest
dollar would be

=ROUND(C22*G11*G17,0)

--
Regards,

Peo Sjoblom

(No private emails please)


"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)