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:
Please Login or Register to view this content.
Last edited by rajeshturaha; 02-21-2015 at 05:28 AM.
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:Please Login or Register to view this content.
The formula works like a charm.
God bless you
Thank you very much, Mr. "rajeshturaha"
On this wonderful solution
=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
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
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
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
Thanks for your feedback and adding reputationOriginally Posted by shimaa01234
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks