Forum Discussion

grapprise's avatar
grapprise
Copper Contributor
Jul 02, 2020

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 know what .444 x 18 =

This is what I did manually - unfortunately I have a thousand to do!

9441852.4448.000
Formulas and Functions

3 Replies

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Jul 02, 2020

    grapprise 

    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)
  • TheAntony's avatar
    TheAntony
    Iron Contributor
    Jul 02, 2020

    grapprise 

    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.

Resources