How do I get rid of this error when there is no data entered into the forumla??
-Justin
How do I get rid of this error when there is no data entered into the forumla??
-Justin
have a look at Iserr and Iserror functions
eg
=IF(ISERROR(B1/C1),0,B1/C1)
=IF(ISERR(B1/C1),"",B1/C1)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks