Conditions

[ahhhmed]

Hi all,

I have the following question for which I need help:

In Column A2:A10 I have a list of items with some empty cells.

In column B2:B10 I have another list of items with some empty cells.

In column C2:C10, the same.

What I want to do is the following:

In column D2:D15 I want to put 6 or 12 or 18

i.e. if a2 and b2 and c2 are not empty, then d2 shows number 18

if any cell of a2:c2 is empty, then d2 shows 12

if two cells are empty, d2 shows 6

if all are empty, d2 remains empty

 

[fred]

IF(COUNTA(A2:C2)=0,6,IF(COUNTA(A2:C2)=1,6,IF(COUNTA(A2:C2)=2,12,18)))

 

[fred]

correction


IF(COUNTA(A2:C2)=0,0,IF(COUNTA(A2:C2)=1,6,IF(COUNTA(A2:C2)=2,12,18)))

 

[ahhhmed]

Thanks, but the formula returns 18 for all cases

 

[fred]

are you sure the blank cells are truly empty without a space such as " "?

 

[fred]

also 0 is not equals to empty.