Jul 02 2020 03:46 AM
Hi I'm trying to remove the first two digits from the full number e.g. 52.444 needs to be .444 so that I can use this number to multiply against another number.
So 944/18 = 52.444 - I need to know what .444 x 18 =
This is what I did manually - unfortunately I have a thousand to do!
944 | 18 | 52.444 | 8.000 |
Jul 02 2020 04:24 AM
You can do this : =(A1/B1)-INT(A1/B1) where A1=944 and B1=18 to get the decimal part of the division and then multiply by the other number.
Jul 02 2020 01:23 PM
You need to remove first two digits (e.g. 152.444 => 2.444) or you need to remove integer part? If the latest, as @TheAntony suggested, or bit shorter
=MOD(944/18,1)