| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
ROUNDING AND 2 FORMUALS IN ONE CELL
Try this:
A1 =10.25 In B1 =CEILING(A1/2,0.25) In C1 =FLOOR(A1/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 | |||
| ROUNDING AND 2 FORMUALS IN ONE CELL | Excel Worksheet Functions | |||
| 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 | |||
| rounding down another cell with a formula | Excel Worksheet Functions | |||
| Rounding and cell totals | Excel Worksheet Functions | |||
Threaded Mode
