=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