Return TRUE if cell contains certain “x” or numbers

Hi all,

I need a formula that returns TRUE if one of the following criteria is met in cell EG13:

cell contains e.g. "x", " x", "xx", "xxx", "5", "10" etc.

and returns FALSE

if the cell contains e.g. "Lux", "-2", "-8", “0”, "Fox” etc.

To put it into words, if the cell contains a positive number (excluding zero) or an “x” (maximum 5) while ignoring spaces but excluding words such as “Fox” it returns TRUE otherwise it returns FALSE. Below is the formula I currently have but it doesn’t seem to work...

Please Login or Register  to view this content.

Can you attach a sample spreadsheet with an example of your expected results?

Try this:

=OR(REPT("x",{1,2,3,4,5})=SUBSTITUTE(EG13," ",""),N(EG13)>0)

That does the job! Thanks!!