Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

if its not 10 = N/A

Status
Not open for further replies.

TJVFree

Technical User
Nov 22, 2010
236
US
Hi,
I’m trying to make a number field show an N/A. Below is the formula I'm using. any help

=IF(B33="",0,IF(B33=N/A,N/A,IF(B33="FAIL",0,20)))


=IF(B38="",0,IF(B38=N/A,N/A,IF(B38="FAIL",0,20)))

TCB
 
=IF(B33="",0,IF(B33=[RED]"[/RED]N/A[RED]"[/RED],[RED]"[/RED]N/A[RED]"[/RED],IF(B33="FAIL",0,20)))


Randy
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top