Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If statement
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 -- Clash ------------------------------------------------------------------------ Clash's Profile: http://www.excelforum.com/member.php...o&userid=18951 View this thread: http://www.excelforum.com/showthread...hreadid=504847 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If statement
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. Clash wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SET statement tutorial | Excel Discussion (Misc queries) | |||
If Statement linked to cell with VLOOKUP problem - getting wrong v | Excel Worksheet Functions | |||
If statement | Excel Discussion (Misc queries) | |||
Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions | |||
IF Statement nightmare | Excel Discussion (Misc queries) |