| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
ROUNDING AND 2 FORMUALS IN ONE CELL
=CEILING(10.25/2,0.25)&" AND "&FLOOR(10.25/2,0.25)
"Joe" wrote: how can i Divide numbers and have results in 2 different cells rounded to the nearest .25 cent round one cell up and on cell down so it equals the total like 10.25/2=5.25 AND 5.00 OR 10.75/2 =5.50 AMD 5.25 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Significant number rounding based on key cell | Excel Worksheet Functions | |||
| excel, how enter 15 digits in a cell without rounding off last? | Excel Worksheet Functions | |||
| cut off number in excel cell vs. rounding | Excel Discussion (Misc queries) | |||
| rounding down another cell with a formula | Excel Worksheet Functions | |||
| Rounding and cell totals | Excel Worksheet Functions | |||
Threaded Mode
