If statement

C

Clash

Morning all,

please help, I am having one of those moments.

I'm trying to check if the sum of four cells is correct against another
cell, and it to tell me "correct" or "wrong".

I know that it's an "IF" statement, but for the life of me I can't get
the structure right.

Cheers

Clash:confused:
 
G

Govind

Hi,

Say the four cells are A1:A4 and you want to check against B1 cell,use

=IF(SUM(A1:A4)=B1,"Correct","Wrong")

Regards

Govind.
 
Top