How to make a formula which multiply 2 cells with X as the value of 0

[Nellycorn]

Hello,
Can anyone please help make formula which I can multiply 2 cells and have X from column A as the value 0 when multiplied, e.g, looks like row 5 from from this Data table. And if possible, make the formula turn the Total Amount as XXX as the value for 0, e.g. look like row 4. If not possible, I'm happy if anyone can just make the formula which X is the value 0 on Column A when multiped with Column B on Column C

 

[jtakw]

Hi,

Not sure what you mean, your description is a bit confusing.

Use either C2, D2 or E2 formula:
C2 works for Any Text in A, E2 Only works for "X"

Book3.xlsx
	A	B	C	D	E
1
2	6	10	60	60	60
3	5	20	100	100	100
4	X	0	XXX	0	XXX
5	X	0	XXX	0	XXX
Sheet1048

Cell Formulas
Range	Formula
C2:C5	C2	=IF(N(A2),A2*B2,REPT(A2,3))
D2:D5	D2	=IF(N(A2),A2*B2,0)
E2:E5	E2	=IF(A2="X","XXX",A2*B2)

 

[Nellycorn]

Hi,

Not sure what you mean, your description is a bit confusing.

Use either C2, D2 or E2 formula:
C2 works for Any Text in A, E2 Only works for "X"

Book3.xlsx
	A	B	C	D	E
1
2	6	10	60	60	60
3	5	20	100	100	100
4	X	0	XXX	0	XXX
5	X	0	XXX	0	XXX
Sheet1048

Cell Formulas
Range	Formula
C2:C5	C2	=IF(N(A2),A2*B2,REPT(A2,3))
D2:D5	D2	=IF(N(A2),A2*B2,0)
E2:E5	E2	=IF(A2="X","XXX",A2*B2)

Hi, sorry that I made it confusing for you. Despite that, you still managed to help me with the formula I need ? thank you so much. All formulas you made are really helpful. I'll use either C2 or E2 formula for my data .

 

[jtakw]

You're welcome, thanks for the feedback.