How can I have a cell show blank if #REF! is showing up currently.
How can I have a cell show blank if #REF! is showing up currently.
Last edited by brook; 11-07-2011 at 11:55 AM.
Assuming your data is in column A try this in column B:
=IF(ISERROR(A1),"",A1)
Steve
Thanks for the help. I ended up doing a conditional format to change the font to white if it errors.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks