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?
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
how to multiply
0
Answers
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$3Multiply values in the column B with the corresponding values in column C:
=(B5-TRUNC(B5))*C5Or, if you want to multiply the after decimal parts of two columns:
=(A5-TRUNC(A5))*(B5-TRUNC(B5))Discussion
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: 4) 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: 111) 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)*7where 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.
Discussion
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: 4) 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: 4889) Apr 17, '18 at 9:27 pm