SOLVED

Simple multiplication

%3CLINGO-SUB%20id%3D%22lingo-sub-1548060%22%20slang%3D%22en-US%22%3ESimple%20multiplication%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1548060%22%20slang%3D%22en-US%22%3E%3CP%3EI%20hope%20you%20can%20help%20I%20have%20the%20number%26nbsp%3B%20164069012%20and%20I%20want%20to%20multiply%20a%20number%20in%20another%20column%20with%20only%20the%20end%20two%20digits%20is%20this%20possible%20please%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1548060%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1548133%22%20slang%3D%22en-US%22%3ERe%3A%20Simple%20multiplication%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1548133%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F741174%22%20target%3D%22_blank%22%3E%40Terdar%3C%2FA%3E%26nbsp%3BYes%20you%20can%20do%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESuppose%20you%20want%20to%20multiple%20with%20cell%20A2%20where%20value%20is%20Ka525%20or%20625...So%20now%20you%20want%20to%20multiple%20with%2025%20only.%20So%20you%20need%20write%20formula%20i.e.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3E164069012%20*%20right(A2%2C2)*1%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBut%20if%20A2%20cell%20contains%20the%20decimal%20number%20then%20you%20should%20use%20below%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DRIGHT(ROUND(G2%2C0)%2C2)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1549558%22%20slang%3D%22en-US%22%3ERe%3A%20Simple%20multiplication%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1549558%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F476378%22%20target%3D%22_blank%22%3E%40jukapil%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethank%20you%20for%20your%20prompt%20response%2C%20but%20I%20can't%20get%20it%20to%20work%20so%20here%20is%20my%20criteria%20three%20columns%3A%3C%2FP%3E%3CP%3EA%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20C%3C%2FP%3E%3CP%3E164069004%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20471%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20(471%20*%2004)%3C%2FP%3E%3CP%3E164014012%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B218%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20(218%20*%2012)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20tried%20your%20formula%20in%20column%20C%20but%20keep%20getting%20VALUE%20so%20I%20am%20doing%20something%20wrong.%20Can%20you%20help%20me%20again%20please%3F%20Many%20thanks%20for%20your%20time.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1550006%22%20slang%3D%22de-DE%22%3ESubject%3A%20Simple%20multiplication%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1550006%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F741174%22%20target%3D%22_blank%22%3E%40Terdar%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EAs%20jukapil%20said%20...%20Here%20is%20a%20small%20example%20that%20simplifies%20Jukail's%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3ENikolino%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%20class%3D%22%22%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1550010%22%20slang%3D%22en-US%22%3EBetreff%3A%20Simple%20multiplication%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1550010%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F722750%22%20target%3D%22_blank%22%3E%40Nikolino%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMany%20thanks%20for%20explaining%20it%20again.%20Thank%20you%20for%20your%20time.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1550029%22%20slang%3D%22de-DE%22%3ESubject%3A%20Simple%20multiplication%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1550029%22%20slang%3D%22de-DE%22%3EIt%20was%20a%20pleasure%20for%20me%20to%20be%20able%20to%20help%20you%20...%20if%20the%20answer%20helped%20you%2C%20please%20tick%20the%20correct%20answer%20so%20that%20others%20can%20also%20find%20out%20from%20it%2C%20a%20little%20like%20would%20also%20be%20good%20...%20but%20think%20that%20this%20jukapil%20is%20it%20earned%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%20%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%20Nikolino%20%3CBR%20%2F%3E%20I%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FLINGO-BODY%3E
New Contributor

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?

5 Replies

@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)

@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.

Best Response confirmed by Terdar (New Contributor)
Solution

@Terdar 

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

 

 

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

@Nikolino 

 

Many thanks for explaining it again. Thank you for your time.

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)