Worksheet formulae problems.

  • Thread starter Thread starter Nevyn907
  • Start date Start date
N

Nevyn907

Hi Folks got a prob you can maybe help me with.

I have a range of cells that contain one of the following numbers 114 115. I
am trying to devise a formulae that will identify whichever number is missing
and duplicate that number in an answer cell
 
=if(countif(a1:c9,114)=0,114,if(countif(a1:c9,115)=0,115,"both there"))

If both are missing, you'll see 114. Is that ok?
 
Back
Top