Hello - new to Excel and learning formula for 1/2/3

[MallyH]

Hello,

I am looking for a formula that will perform some maths after a third /. So for example on one cell I have 1/2/3 or x/y/z and on another column I need a formula which will sh x/y/z(*2).

Any help appreciated and sorry if it seems simple, as I am new to excel.

 

[6StringJazzer]

What exactly do you have in the first cell? Do you have some formula that results in a number like

=1/2/3

and displays 0.166667? Or do you have a string of text that looks like "1/2/3"?

If the first formula results in a number then the formula is

=A1*2

But that seems so simple, even if you are new to Excel, it is probably not your question. Please be more explicit about 1) What is in the first cell, and 2) what result you want in the second cell. Concrete examples are very helpful.

 

[MallyH]

What exactly do you have in the first cell? Do you have some formula that results in a number like

=1/2/3

and displays 0.166667? Or do you have a string of text that looks like "1/2/3"?

If the first formula results in a number then the formula is

=A1*2

But that seems so simple, even if you are new to Excel, it is probably not your question. Please be more explicit about 1) What is in the first cell, and 2) what result you want in the second cell. Concrete examples are very helpful.

Hi thanks for the reply. In the first cell I have 1/2/3 but in the call I need the formula , I need to times the 3 by 2. So it should result in 1/2/6.

Sorry for the poor example

 

[jtakw]

Hi,

You should give at least a handful of samples.
Assuming those are Text strings.
If your data is Always single digits, (e.g. #/#/#), it could be much simpler.

Book3.xlsx
	A	B	C	D	E
1	Variable digits			Single digits
2	1/22/33	1/22/66		1/2/3	1/2/6
3	11/234/99	11/234/198		7/8/6	7/8/12
Sheet1041

Cell Formulas
Range	Formula
B2:B3	B2	=LEFT(A2,FIND("/",A2,FIND("/",A2)+1))&REPLACE(A2,1,FIND("/",A2,FIND("/",A2)+1),"")*2
E2:E3	E2	=LEFT(D2,4)&RIGHT(D2)*2

 

[MallyH]

Perfect - Thankyou and yes I see your point in requesting better examples which I will do I. Future

 

[jtakw]

You're welcome, thanks for the feedback.