Jul 27 2020 07:51 AM
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?
Jul 27 2020 08:23 AM
@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)
Jul 28 2020 01:54 AM
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.
Jul 28 2020 06:31 AM
SolutionAs jukapil said ... here is a small example that simplifies Jukail's
Nikolino
I know I don't know anything (Socrates)
Jul 28 2020 06:35 AM
Jul 28 2020 06:44 AM
Jul 28 2020 06:31 AM
SolutionAs jukapil said ... here is a small example that simplifies Jukail's
Nikolino
I know I don't know anything (Socrates)