software

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 quot;correctquot; or quot;wrongquot;.

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

Cheers

Clash--
Clash
------------------------------------------------------------------------
Clash's Profile: www.excelforum.com/member.php...oamp;userid=18951
View this thread: www.excelforum.com/showthread...hreadid=504847Hi,

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

=IF(SUM(A1:A4)=B1,quot;Correctquot;,quot;Wrongquot;)

Regards

Govind.

Clash wrote:
gt; Morning all,
gt;
gt; please help, I am having one of those moments.
gt;
gt; I'm trying to check if the sum of four cells is correct against another
gt; cell, and it to tell me quot;correctquot; or quot;wrongquot;.
gt;
gt; I know that it's an quot;IFquot; statement, but for the life of me I can't get
gt; the structure right.
gt;
gt; Cheers
gt;
gt; Clash
gt;
gt;