To know if something is correct means you have to know beforehand what the
answer will be.

If, in this case =A1+B1 "must" be 20 then in D1 enter =IF(C1=20,OK","Not
OK")


Gord Dibben MS Excel MVP

On Sat, 26 May 2007 11:40:00 -0700, brownang
wrote:

Obviously I know how to do the calculation formula but I'm unsure as to
whether to use an if statement for the checking of the formula.

"brownang" wrote:

I want to put values in cells A1 & B1. I then want to type a formula into
cell C1 to add up A1 & B1. I want cell D1 to check that the formula in cell
C1 is correct and to display a relevant message, e.g. correct or incorrect.
What is the easiest way around this? Thanks