Aug 8, 2003 #1 rusel01 MIS Aug 6, 2003 13 0 0 US How can I have the field show a blank value instead of showing up as #VALUE! ?
Aug 8, 2003 #2 carrr Technical User Sep 10, 2001 3,543 0 0 US Use ISERROR, most likely. However, posting your formula would help out, as that might not be the most effeicient approach... Upvote 0 Downvote
Use ISERROR, most likely. However, posting your formula would help out, as that might not be the most effeicient approach...
Aug 8, 2003 1 #3 Zathras Programmer Nov 12, 2002 3,317 0 0 US Generally with the use of the ISERROR( ) function inside an IF( ) function. Code: =IF(ISERROR(A1/B1),"",A1/B1) If you need more help, please be more specific with what you are trying to do. Upvote 0 Downvote
Generally with the use of the ISERROR( ) function inside an IF( ) function. Code: =IF(ISERROR(A1/B1),"",A1/B1) If you need more help, please be more specific with what you are trying to do.