Validation ?:Accepting both Numbers AND specific letters("N","n","
 

Can anyone help me with this Validation set-up?:

On example cell "E5":

Can Only equal numbers 0.

OR

The letters: N, n, C, c.

For some reason the Validation set-up will only let me validate Numbers
alone, or Letters alone-is their anyway (any formula?) I can use to have both
criteria in place?

Thank you for the help.

Validation ?:Accepting both Numbers AND specific letters("N","n","
 

Custom
and formula is:
=or(e5="n",e5="c",and(isnumber(e5),e50))



Antonio wrote:

Can anyone help me with this Validation set-up?:

On example cell "E5":

Can Only equal numbers 0.

OR

The letters: N, n, C, c.

For some reason the Validation set-up will only let me validate Numbers
alone, or Letters alone-is their anyway (any formula?) I can use to have both
criteria in place?

Thank you for the help.

--

Dave Peterson

Validation ?:Accepting both Numbers AND specific letters("N","
 

Thank you so much Dave!

"Dave Peterson" wrote:

Custom
and formula is:
=or(e5="n",e5="c",and(isnumber(e5),e50))



Antonio wrote:

Can anyone help me with this Validation set-up?:

On example cell "E5":

Can Only equal numbers 0.

OR

The letters: N, n, C, c.

For some reason the Validation set-up will only let me validate Numbers
alone, or Letters alone-is their anyway (any formula?) I can use to have both
criteria in place?

Thank you for the help.

--

Dave Peterson