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
Assuming that you have Excel 2013 or later** try this in BB9
** I suggest that you update your Account details (click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)
I'm wondering though that it might be simpler to run your macro anyway and have it check for the reference and either sweep or do nothing depending on the check result.
Hot ****!! Thank you Peter SSs - that worked like a charm. I updated my account details, I'm using 365. This really helps me a lot, thanks again for taking the time. I'm a GPU expert, if you want to know anything about the latest ones, drop me a line (email@example.com) and/or visit my site (www.jonpeddie.com). Cheers