Please help

[santoshchudappa]

How to add three formula to result three answer in single sheet?
in excel sheet column M2 needs to be built three formula mentioned in M3, M4, M5
Can you please help me?

 

[Alex Blakenburg]

The formula you have at the moment appears to be one column out. H is "text" and the multiplication will always fail.
Surely you mean I3*J3*K3.
Your 3 formulas look identical, what do you want the other 2 to do differently and in what column / row do you want them

 

[santoshchudappa]

Hi Alex,
Thank you for reply, Here my question
1) I have updated my question in column M.
can you pl help me out to combine all formula in column N2 to get answer in single cell using conditional formula.
I am unable to attach file so attached image of my sheet.

kindly request for your help. Thanks

 

[DanteAmor]

What if F and G are not the same?
How to know if it is multiplied by 10, or by 8 or by 7.5?

Dante Amor
	F	G	H	I	J	K	L	M	N
1	Courier	SubC	state	L	B	H	Actual		Weight
2	Safe	Safe	Delhi	18	18	12	40		22.50
3	VRL	VRL	Delhi	18	18	12	40		18.00
4	FedEx	FedEx	Delhi	18	18	12	40		16.88
Hoja1

Cell Formulas
Range	Formula
N2	N2	=IF(F2=G2,((I2*J2*K2)/1728)*10,0)
N3	N3	=IF(F3=G3,((I3*J3*K3)/1728)*8,0)
N4	N4	=IF(F4=G4,((I4*J4*K4)/1728)*7.5,0)

 

[santoshchudappa]

What if F and G are not the same?
How to know if it is multiplied by 10, or by 8 or by 7.5?

Dante Amor
	F	G	H	I	J	K	L	M	N
1	Courier	SubC	state	L	B	H	Actual		Weight
2	Safe	Safe	Delhi	18	18	12	40		22.50
3	VRL	VRL	Delhi	18	18	12	40		18.00
4	FedEx	FedEx	Delhi	18	18	12	40		16.88
Hoja1

Cell Formulas
Range	Formula
N2	N2	=IF(F2=G2,((I2*J2*K2)/1728)*10,0)
N3	N3	=IF(F3=G3,((I3*J3*K3)/1728)*8,0)
N4	N4	=IF(F4=G4,((I4*J4*K4)/1728)*7.5,0)

What if F and G are not the same?
How to know if it is multiplied by 10, or by 8 or by 7.5?

Dante Amor
	F	G	H	I	J	K	L	M	N
1	Courier	SubC	state	L	B	H	Actual		Weight
2	Safe	Safe	Delhi	18	18	12	40		22.50
3	VRL	VRL	Delhi	18	18	12	40		18.00
4	FedEx	FedEx	Delhi	18	18	12	40		16.88
Hoja1

Cell Formulas
Range	Formula
N2	N2	=IF(F2=G2,((I2*J2*K2)/1728)*10,0)
N3	N3	=IF(F3=G3,((I3*J3*K3)/1728)*8,0)
N4	N4	=IF(F4=G4,((I4*J4*K4)/1728)*7.5,0)

Thanks a lot DanteAmor,

Now, How can I combine and set all these formula in column N2 then If I change courier name in column F2 and column G2 after that result to be shown or value to be changed in column N2 (where I will combine all formula)


I request you please help me to resolve this issue. Thanks

​

 

[DanteAmor]

How can I combine and set all these formula in column N2 then If I change courier name in column F2 and column G2

You must show with examples all the possible combinations and the result for each combination.
Use the XL2BB tool to put examples here.