Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula
I am tring to create a formula that will divide a number by 2 and then insert
the number to the lowest 10th in the cell Example 65 divieded by 2 +32.5 but in the cell it would show 30 is this posible Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula
=ROUNDDOWN(32.5,-1) will give you the number 30
=ROUNDDOWN(65/2,-1) will give you the number 30 in your example -- Wag more, bark less "Marvin" wrote: I am tring to create a formula that will divide a number by 2 and then insert the number to the lowest 10th in the cell Example 65 divieded by 2 +32.5 but in the cell it would show 30 is this posible Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula
"Brad" wrote: =ROUNDDOWN(32.5,-1) will give you the number 30 =ROUNDDOWN(65/2,-1) will give you the number 30 in your example -- Wag more, bark less "Marvin" wrote: I am tring to create a formula that will divide a number by 2 and then insert the number to the lowest 10th in the cell Example 65 divieded by 2 +32.5 but in the cell it would show 30 is this posible Thanks Thanks this work if I insert the cel that I wish to divide |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|