how do i create a formula to divide a number by 2 and then display it to the
nearest 5

99 divided 2 = 49.5 and then have the display read 45

or

74 divided by 2 = 37 and then display 35

=ROUND(A1/10,0)*5
--
Gary''s Student - gsnu200794


"Marvin" wrote:

how do i create a formula to divide a number by 2 and then display it to the
nearest 5

99 divided 2 = 49.5 and then have the display read 45

or

74 divided by 2 = 37 and then display 35

Try this:

=FLOOR(A1/2,5)

where A1 is your starting number.

Hope this helps.

Pete

On Jul 3, 12:24*pm, Marvin wrote:
how do i create a formula to divide a number by 2 and then display it to the
nearest 5

99 divided 2 = 49.5 and then have the display read 45

or

74 divided by 2 = 37 and then display 35