Data Validation Upper Case & "N/A" Exception in Number Field

[dparteka]

I'm attempting to create a custom data validation that forces only upper-case and makes the text "N/A" exception in a field that is formatted to output only numbers. I have code for the upper-case portion and the "N/A" portion but am unable to bring them together in a single validation formula string... see the attached workbook for further explanations. Thank you for looking.

 

[NARAYANK991]

Hi ,

Try this :

=OR(AND(EXACT(H18, UPPER(H18)), H18 = "N/A", ISTEXT(H18)), ISNUMBER(H18))

Narayan

 

[dparteka]

Narayan... excellent, works superbly
Thank you