I have a column that is a series of calculations
Occasionally, one of the cells a calculation is based upon has text data inserted, because no data exist for that cell, say, E20/F20,
F20 has text indicating no numerical data is available
If this occurs, how can I make my formula to indicate something other than #VALUE!
I am not concerned with what is put into the cell, only removing the error
Thank you
Bookmarks