i have a column in which i have values after decimals.

i.e 29.33, 34.45, 45.43 etc. now i want to multiply the only after decimal values with a number. how it be possible?

Other Excel Questions

Excel Tutorials

0

i have a column in which i have values after decimals.

i.e 29.33, 34.45, 45.43 etc. now i want to multiply the only after decimal values with a number. how it be possible?

0

Selected Answer

Hello Salahuddin,

What about using these formulas, assuming you have a data in B5:

Multiply with a fix value, e.g. 7:

`=(B5-TRUNC(B5))*7 `

Multiply with a fix cell value, e.g.A3:

`=(B5-TRUNC(B5))*$A$3`

Multiply values in the column B with the corresponding values in column C:

`=(B5-TRUNC(B5))*C5`

Or, if you want to multiply the after decimal parts of two columns:

`=(A5-TRUNC(A5))*(B5-TRUNC(B5))`

i have latitude and longitude in decimal i.e 33.98233 36.43422, base on your above formula i convert it into separate cells. but now want to combine it into single cell i.e. degree minute second.

SALAHUDDIN (rep: 2) Apr 17, '18 at 4:54 am

Thanks for selecting as answer.

If you want to convert the multiplied result into degree, minute and seconds, it could be suitable for a new thread. However, I guess you might be interested in vba or online conversion.

If you want to convert the multiplied result into degree, minute and seconds, it could be suitable for a new thread. However, I guess you might be interested in vba or online conversion.

Chhabi Acharya (rep: 102) Apr 17, '18 at 7:00 am

0

I'm not sure to understand your question correctly. If it is the integer you are after then the TRUNC() function is the one to use, as suggested by Chhabi. However, if you wish to multiply the decimal value only then it would be something like

`=Mod(B5,1)*7`

where B5 holds the original value and 7 is the number by which to multiply which, of course, could also be the value of a referenced cell.

i have latitude and longitude in decimal i.e 33.98233 36.43422, base on your above formula i convert it into separate cells. but now want to combine it into single cell i.e. degree minute second

SALAHUDDIN (rep: 2) Apr 17, '18 at 6:26 am

Hello Salahuddin,
This question already has a selected answer. Please ask your new question in a new thread. And when you do please show an example of what you mean.

Variatus (rep: 2185) Apr 17, '18 at 9:27 pm