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
1833
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 16, 2020
135
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
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

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..