Hi, and thanks
The formula in "this sheet," one of several in a workbook is: cell bb10=if(othersheet!bb10>0.001, othersheet!bb10,(ba10*BB11)) The logic is if there is a number in othersheet bb10, then use it, if it is empty then multiply the previous cell by a factor (bb11). The problem is when new data gets entered in othersheet, it doesn't sync with "this sheet." I can fix that by copying cell AZ and sweeping it across the row. But sometimes I forget to check (its a large a very large workbook and I get a lot of interruptions). I want to say (logically in bb9 "does bb10 contain othersheetbb10?" If the answer is "fail," then I will at least have an error warning. My ultimate goal is if the answer says fail, that kicks off a macro that then does the sweep operation (I've already built and named that macro). So my question is, is there a way to check a ("if") formula to determine if it has a specific variable? Thanks for any help you can render. Jon