View Single Post
  #2   Report Post  
Barb R.
 
Posts: n/a
Default

=round((C22*G11)*G17),0) should do it.

If you want the result to the nearest PENNY, do this:

=round((C22*G11)*G17*100),0)/100

"Chandra" wrote:

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)