LinkBack URL
About LinkBacks
A process of multiplying two numbers after separated from the text
I want a formula in column "D", to achieve the result in it
A process of multiplying two numbers after separated from the text
I want a formula in column "D", to achieve the result in it
Last edited by shimaa01234; 02-21-2015 at 04:59 AM.
Hi.
Not sure I understand. Sometimes the desired result is achieved by also including the column B value in the multiplication; sometimes it isn't.
Can you clarify?
Regards
Plz explain your requirement with an example
Rgd
RT
If my answer(s) helped you, please add me reputation by click on *
Mr professorial "XOR LX"
I want a formula in column "d" It make multiplication the numbers between texts
If a single figure without text, multiplying in the cell in column "B"
try
in D or E col and drag it downFormula:
=IFERROR(VALUE(MID(C3,1,FIND("L.S",C3)-1))*VALUE(CLEAN(SUBSTITUTE(SUBSTITUTE(C3,LEFT(C3,FIND("L.S",C3)+2),""),"D",""))),C3*B3)
Last edited by rajeshturaha; 02-21-2015 at 05:28 AM.
The formula works like a charm.
God bless you
Thank you very much, Mr. "rajeshturaha"
On this wonderful solution
Thank you very much, Mr. "rajeshturaha"
But I use Office 2003
If there are two values in column C, are they always separated by a linebreak?
Also, are the two text entries in those cases always "L.S" and "D"?
Regards
For 2003
Formula:=IF(ISERROR(VALUE(MID(C3,1,FIND("L.S",C3)-1))*VALUE(CLEAN(SUBSTITUTE(SUBSTITUTE(C3,LEFT(C3,FIND("L.S",C3)+2),""),"D","")))),C3*B3,VALUE(MID(C3,1,FIND("L.S",C3)-1))*VALUE(CLEAN(SUBSTITUTE(SUBSTITUTE(C3,LEFT(C3,FIND("L.S",C3)+2),""),"D",""))))
Yes Mister "XOR LX"
Thank you very much for your participation
Because this is an honor for me
Mister "Siva"
This is too much for me, a genius solution
God bless you
Thanks for your feedback and adding reputationOriginally Posted by shimaa01234
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
=IF(ISTEXT(C3),LOOKUP(9^9,LEFT(C3,ROW(INDIRECT("1:"&LEN(C3))))*1)*LOOKUP(9^9,RIGHT(TRIM(SUBSTITUTE(C3,"D","")),ROW(INDIRECT("1:"&LEN(C3))))*1),C3*B3)
Try this and copy towards down
Glade it helped you.
If you have your desired result plz mark this thread as solved.
Click * to add to reputation whose answer helped you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks