Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Rounding Formulas
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) |
#2
|
|||
|
|||
=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) |
#3
|
|||
|
|||
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) |
#4
|
|||
|
|||
=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) |
#5
|
|||
|
|||
"?B?Q2hhbmRyYQ==?=" wrote in
: 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) Do you just want to round what it SHOWS, or what it calculates? In other words, if you're going to be doing more calculations with the value in that cell, do you want to do use the rounded off value in the new calculations? Because if you only need to round off what the cell DISPLAYS, you can do that by formatting the cell -- you don't need to change the formula at all. -- Marc. |
#6
|
|||
|
|||
Or
=ROUND(C22*G11*G17,2) In article , "Barb R." wrote: If you want the result to the nearest PENNY, do this: =round((C22*G11)*G17*100),0)/100 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
rounding a formula's number | Excel Worksheet Functions | |||
formulas for rounding | Excel Discussion (Misc queries) | |||
Problem with named formula's | Excel Worksheet Functions | |||
specific rounding of formulas which may need to include an IF stat | Excel Worksheet Functions | |||
calculating formulas for all workbooks in a folder | Excel Worksheet Functions |