Help me to count 2 cells

Solved/Closed
Report
Posts
27
Registration date
Tuesday November 18, 2014
Status
Member
Last seen
May 21, 2015
-
Posts
27
Registration date
Tuesday November 18, 2014
Status
Member
Last seen
May 21, 2015
-
helo,

please help me to count 2 celles
A1 Is either 0 or 2, A2 is either 0 or 2

IF A1+A2=0 A3 should be 6,
IF A1+A2=2 A3 Should be 3
if A1+A2=4 A3 Should be 0

1 reply

Posts
1950
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
January 9, 2022
148
mathewmunna, Good morning.

Try this one:
A3 --> =IF(A1+A2=0,6,IF(A1+A2=2,3,0))

Is this what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
1
Posts
27
Registration date
Tuesday November 18, 2014
Status
Member
Last seen
May 21, 2015

Thank you..Mazzaropi..This is what i was looking for..
0