ExcelBanter - Formula

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Formula (https://www.excelbanter.com/excel-discussion-misc-queries/191515-formula.html)

Marvin

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

Brad

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

Marvin

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

All times are GMT +1. The time now is 05:58 PM.