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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Antonio - 22 Apr 2008 16:13 GMT

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.

Reply to this Message

Dave Peterson - 22 Apr 2008 16:55 GMT

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

> Can anyone help me with this Validation set-up?:
>
[quoted text clipped - 11 lines]
>
> Thank you for the help.

Signature

Dave Peterson

Reply to this Message

Antonio - 22 Apr 2008 17:07 GMT

Thank you so much Dave!

> Custom
> and formula is:
[quoted text clipped - 15 lines]
> >
> > Thank you for the help.

Reply to this Message