IF Function After DELTA

[MSchleicher]

I need the IF function to work after the delta function. The codes I want are located below. I think I am nesting the formula incorrectly. It returns as FALSE when it should be Correct.

I'm assuming it is a simple fix. Any guidance is appreciated.

Please Login or Register  to view this content.

As a side note, both functions work correctly when input on their own.

I tried different things such as stacking them, placing a comma between the two and removing the equal sign, etc. None of them worked.

[scottylad2]

Try =IF(DELTA(SUM(B2:E2),A2)=1,"correct","error")

[scottylad2]

=IF(DELTA(SUM(B2:E2),A2)=1,"correct","error") could be shortened to =IF(SUM(B2:E2)=A2,"correct","Error")

[MSchleicher]

=IF(DELTA(SUM(B2:E2),A2)=1,"correct","error") could be shortened to =IF(SUM(B2:E2)=A2,"correct","Error")

Works perfectly, thanks!