I want to be able to create a worksheet where a cell checks that a preceding cell has a formula in it and then displays an appropriate message (in another cell) according to whether or not it is correct. I'm not sure whether it is a macro or an if statement.
E.g. cells A1 & B1 have values in them, cell C1 is where the user types in the formula and cell D1 checks the contents of C1 and displays a relevant message, eg. correct or incorrect.
Bookmarks