| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
formula with text and rounding
I am trying to add text to the end of a formula. My formula returns 3.103 but I want it rounded to 2 places and keep the numeric properties so I can use it in other formulas and add "x". When I try to use the custom format option #.##"x" it returns only one decmal, that is 3.1x instead of 3.10x. How can I make it show 2 decmil places and keep the numeric cell properties?
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ROUNDING FORMULA =ROUND(B12/$B$10,1) ROUNDING TO HIGH | Excel Worksheet Functions | |||
| I need a formula with rounding up & rounding down to the nearest . | Excel Worksheet Functions | |||
| Problems: rounding & formatting Text/# combinations | Excel Discussion (Misc queries) | |||
| Problems: rounding & formatting Text/# combinations | Excel Discussion (Misc queries) | |||
| rounding a formula in a cell, then replace the formula | Excel Programming | |||
Threaded Mode
