needing formula to achieve if/then calculations

[paquirl]

Hi I'm needing a formula in R2 to multiply value in L2, M2, or N2 (depending on which is populated with a value; if more than one populated with a value, error out) by Q2

 

[Fluff]

What do you mean by

if more than one populated with a value, error out) by Q2

Can you post some sample data.

 

[DanteAmor]

Try this:

varios 21jun2023.xlsm
	L	M	N	O	P	Q	R
2	1	2	3			4	error
3	1	2				4	error
4	1					4	4
5		2	3			4	error
6			3			4	12
7		2				4	8
8	1		3			4	error
Hoja3

Cell Formulas
Range	Formula
R2:R8	R2	=IF(COUNTA(L2:N2)=1,MAX(L2:N2)*Q2,"error")

 

[paquirl]

Please see attached image.

 

[Fluff]

That does not answer my question, nor does the image explain anything.

 

[paquirl]

That does not answer my question, nor does the image explain anything.

my apologies, i did not see the question. i meant if more than one of the L M or N columns has a value it should error out

 

[Fluff]

In that case try the formula that Dante supplied.