Previous Topic Next Topic

Help me to count 2 cells

Solved/Closed
mathewmunna Posts 22 Registration date Tuesday November 18, 2014 Status Member Last seen May 21, 2015 - Nov 26, 2014 at 12:57 AM
mathewmunna Posts 22 Registration date Tuesday November 18, 2014 Status Member Last seen May 21, 2015 - Nov 26, 2014 at 08:32 AM
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
Related:

1 response

Answer 1 / 1
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Nov 26, 2014 at 07:50 AM
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
mathewmunna Posts 22 Registration date Tuesday November 18, 2014 Status Member Last seen May 21, 2015
Nov 26, 2014 at 08:32 AM
Thank you..Mazzaropi..This is what i was looking for..
0