Function that checks multiple cells for a value, then returns a value

[mexitronic]

I need to create a formula that will check 3 separate cells (K2,N2,Q2). If K2 has a value in it and no values in N2 or Q2, then it would return a 1. If K2 & N2 have a value and no value in Q2, it would return a 2. If K2, N2 & Q2 all have values, it would return a 3. If K2, N2 & Q2 are blank then, cell would also be blank. I would appreciate any input on how I could structure this formula.

 

[lenze]

Hi and welcome to the Board!!
Here's one way

=CHOOSE(COUNTA(K2,N2,Q2)+1,"",1,2,3)

Here's another

=IF(COUNTA(K2,N2,Q2)=0,"",COUNTA(K2,N2,Q2))

lenze