Forum Discussion
grapprise
Jul 02, 2020Copper Contributor
Formula
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 kno...
SergeiBaklan
Jul 02, 2020Diamond Contributor
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)