Forum Discussion

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
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)
Rechts.xlsx8 KB

5 Replies

NikolinoDE
Platinum Contributor
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)
Rechts.xlsx8 KB
- Terdar
  Copper Contributor
  Jul 28, 2020
  NikolinoDE
  
  Many thanks for explaining it again. Thank you for your time.
  - NikolinoDE
    Platinum Contributor
    Jul 28, 2020
    It was a pleasure for me to be able to help you ... if the answer helped you, please tick the correct answer so that others can also find out from it, a little like would also be good ... but think that this jukapil is it earned 🙂
    
    Nikolino
    I know I don't know anything (Socrates)
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
  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