If (or case?) help
Posted on 2013-10-18
I have a command button that will check the values in a specific range to make sure they are correct. The cell are formatted number with 2 decimal places.
The range is from D7:D14 and cell D15.
If the value is any cell does not match the answer, I'd like to tell the user that the answer is incorrect and to check their formula or function. For example, the answer for D7 maybe 13.23 but the user got 565.
The only cells not protected will be those that have formulas or functions. I'm not sure a Case or If statement is best to use and what the code would lokk like.