Hi
I require a formula for C15. If any cell in the range D14 to NK14 has the word Error, then show "Error" in C15, else leave blank. Cells D14 to NK14 represent the quotient of D13 to NK13 and a constant.
eg. D14=D13/constant. There are some instances where some values in the row 14 will reflect an "error" msg. I need C15 to tell me "Error" if there is any instance of an error in any Row14
(I am having difficulty uploading a sample)
your help is appreciated
Roxio
Bookmarks