=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?

Nevyn907 wrote:

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

--

Dave Peterson