If for example :
A1 contains 31 x 41"
i want the result in b1
how will u calculate the data in a1
whats the formula
" symbol stands for inches
If for example :
A1 contains 31 x 41"
i want the result in b1
how will u calculate the data in a1
whats the formula
" symbol stands for inches
=left(a1,2)*mid(a1,6,2)
Willem
English is not my native language sorry for errors
Please correct me if I'm completely wrong
Many thanks for your prompt reply......
Could you please define it a bit clearly......
I did not understand the formula if a1 contains 31 x 41" i want the result as 31x41 = 1271 in b1
=TRIM(LEFT(A1,FIND("x",A1,1)-1)) * MID(A1,B1+1,FIND("""",A1,1)-FIND("x",A1,1)-1)
or ??
=(LEFT(A1,FIND("x",A1,1)-1))*MID(A1,FIND("x",A1,1)+2,FIND("""",A1)-(FIND("x",A1,1)+2))
If i write 31*41 in a1 calculate this in b1
Now you change the question!A1 contains 31 x 41"
..
..
" symbol stands for inches
is it now with or without ""
A1 : 31
B1 : 41
c1 : =A1*B1
.......... but because you are mixing text and numbers you need :-
=TRIM(LEFT(A1,FIND("x",A1,1)-1)) * MID(A1,B1+1,FIND("""",A1,1)-FIND("x",A1,1)-1)
Elegant Simplicity............. Not Always
If i write 31*41 in a1 calculate this in b1
=left(a1,2) gives a result of 31
=mid(a1,6,2) gives a result of 41
31*41=1271
it is with " symbol only sir
Look here my solution of #2 and #7
Its working thank you
how to calculate this
if a1 contains quantity 190p + 180s
and b1 contains weight 18.38
i want the result in c1 as total weight
for say weight of one packet is 18.38, what is the weight for 190 packets + 180 balance sheets
"Play" with the 'find' formula to locate the different letters in a cell
It is not working with datas containing 31.5 x 41.5" decimals
Pls give me the example
I hope this wil explane the formula.
sir can i have ur email id i want to send the screen shots and the calculation of paper formula as we deal wid paper industry
if the size of the paper is in CMS :
L X B X GSM / 1,00,000 = ( ANSWER ) * NO OF SHEETS PER PKT
IE, BY DEFAULT WE GET WEIGHT FOR 100 SHEETS IF IT IS 250 SHEETS PER PKT WE MULTIPLY 2.5 WITH W=THE ANSWER
if the size of the is in INCHES :
L X B X GSM / 15,500 = ( ANSWER ) * NO OF SHEETS PER PKT
can u send me some simple example for the last file u have sent as an attachment
or can i have ur email id to send the exact file of my requirement
Attach is the file for your reference of our working......
Like said before in the last mail of our calculation and formulas
how to convert the entire sheets to upper case in excel 2007
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks