Forum Discussion

Terdar's avatar
Terdar
Copper Contributor
Jul 27, 2020
Solved

Simple multiplication

I hope you can help I have the number  164069012 and I want to multiply a number in another column with only the end two digits is this possible please?
Formulas and Functions
  • NikolinoDE's avatar
    NikolinoDE
    Jul 28, 2020

    Terdar 

    As jukapil said ... here is a small example that simplifies Jukail's

     

     

    Nikolino
    I know I don't know anything (Socrates)

jukapil's avatar
jukapil
MCT
Jul 27, 2020

Terdar Yes you can do it.

 

Suppose you want to multiple with cell A2 where value is Ka525 or 625...So now you want to multiple with 25 only. So you need write formula i.e.

 

164069012 * right(A2,2)*1 

 

But if A2 cell contains the decimal number then you should use below:

 

=RIGHT(ROUND(G2,0),2)

  • Terdar's avatar
    Terdar
    Copper Contributor
    Jul 28, 2020

    jukapil 

     

    thank you for your prompt response, but I can't get it to work so here is my criteria three columns:

    A                                 B                          C

    164069004                  471                   (471 * 04)

    164014012                  218                    (218 * 12)

     

    I tried your formula in column C but keep getting VALUE so I am doing something wrong. Can you help me again please? Many thanks for your time.

Resources