Formulas
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 |
Formulas
=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 |
Formulas
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 |
All times are GMT +1. The time now is 04:21 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com