Creating a Custom Excel Formula

[Beth]

Is it possible to create a formula in Excel which will
identify a value within a range of cells and create a
text base response if that value is located.

For example:

If the number "1" is input into any of the cells in a
range, the text result would be "Yes" or if there is
a "2" located in any of the cells within the same range,
the result would be "No".

Please help!

 

[Don Guillett]

try

=IF(SUMIF(E1:E4,1)>0,"yes","no")

 

[Beth]

Thanks for the quick response.

Do you know if it possible to have a text response to
multiple values. For example, like I stated originally,
if the number 1 is found in the range of cells, "Yes"
would be the result, if the number 2 if found, "no" would
be the result and if the number 3 is found, "Maybe" would
be the result. If none of the values or anything else is
located in the range of cells, the result would be blank.

Hope that makes sense and thanks again for the help!

 

[Don Guillett]

One way for 1-3.
=IF(MAX(G1:G10)=0,"",CHOOSE(MAX(G1:G10),"y","N","M"))
or data validation to only allow 1,2, or 3