ExcelBanter - ROUNDING AND 2 FORMUALS IN ONE CELL

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - ROUNDING AND 2 FORMUALS IN ONE CELL (https://www.excelbanter.com/excel-worksheet-functions/121021-re-rounding-2-formuals-one-cell.html)

Teethless mama

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

All times are GMT +1. The time now is 11:33 AM.