If with 3 conditions and 3 possible answers

[iamsacti]

Hi, guys
First, excuse me for my english. I hope you guys understand what I mean. I have the following data and conditions:

A1 = 7
B1 = 2
C1 = 9
(the answer would be 7)

A1 = 0
B1 = 5
C1 = 3
(the answer would be 5)

A1 = 0
B1 = 0
C1 = 4
(the answer would be 4)

A1 = 0
B1 = 0
C1 = 0
(the answer would be 0)

if A1 has value other than 0, I want A1 as the answer (regardless if in B1 or C1 have a value or not). If A1= 0, I want B1 as the answer. and if A1 and B1 = 0, I want C1 as the answer. But if A1, B1, and C1 = 0, I want 0 as the answer.

What is the formula for those condition?

Thanks

 

[Trebor76]

Hi iamsacti,

Adapting the chosen formula from here, this should do the job:

=IF(SUM($A$1:$A$3)=0,0,INDEX($A$1:$A$3,MATCH(TRUE,INDEX($A$1:$A$3<>0,),0)))

Regards,

Robert

 

[Michael M]

did I miss something....

=IF(AND(A1=0,B1=0),C1,IF(A1=0,B1,IF(A1<>0,A1,0)))

 

[iamsacti]

did I miss something....

=IF(AND(A1=0,B1=0),C1,IF(A1=0,B1,IF(A1<>0,A1,0)))

Wow, it works. Thank you very much, Michael

 

[Michael M]

glad to help...

 

[Peter_SSs]

Would this also work for you?

=IF(A1&B1="00",C1,IF(A1=0,B1,A1))

 

[jtakw]

Hi,

Here's another way, will show any value other than 0 (zero) in order of A1, B1, C1 (including negatives):

Book1
	A	B	C	D	E
1	7	2	9		7
2	0	5	3		5
3	0	0	4		4
4	0	0	0		0
5	0	1	0		1
Sheet347

Cell Formulas
Range	Formula
E1	=IF(A1,A1,IF(B1,B1,C1))