Mar 23, 2015 #1 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
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
Mar 23, 2015 #2 dhookom Programmer Jun 24, 2003 22,536 US This question should probably posted in forum68. This forum is for Access Queries. Duane Hook'D on Access MS Access MVP Upvote 0 Downvote
This question should probably posted in forum68. This forum is for Access Queries. Duane Hook'D on Access MS Access MVP
Mar 24, 2015 #3 randy700 Programmer Sep 25, 2003 2,384 US =IF(B33="",0,IF(B33=[RED]"[/RED]N/A[RED]"[/RED],[RED]"[/RED]N/A[RED]"[/RED],IF(B33="FAIL",0,20))) Randy Upvote 0 Downvote
=IF(B33="",0,IF(B33=[RED]"[/RED]N/A[RED]"[/RED],[RED]"[/RED]N/A[RED]"[/RED],IF(B33="FAIL",0,20))) Randy
Mar 25, 2015 Thread starter #4 TJVFree Technical User Nov 22, 2010 236 US Thanks Randy TCB Upvote 0 Downvote