Combing IF and Round with an excel check formula

[rlc]

I have multiple pages that require a check. I have manually checked, and verified the tabs do total correctly. This an example of the existing syntax: =IF(A27=Blue A27+Green A27+Purple A27,0,"check"). I need it round to a specific decimal, because it is returning "check" and it should be zero. Thanks for any assistance you can provide.

 

[Aladin Akyurek]

I have multiple pages that require a check. I have manually checked, and verified the tabs do total correctly. This an example of the existing syntax: =IF(A27=Blue A27+Green A27+Purple A27,0,"check"). I need it round to a specific decimal, because it is returning "check" and it should be zero. Thanks for any assistance you can provide.

Is this...

=IF(A27=Blue A27+Green A27+Purple A27,0,"check")

accepted in your Excel? I'd expect it would not succeed.

 

[Joe4]

Perhaps something like:
=IF(ROUND(A27,2)=ROUND(Blue!A27+Green!A27+Purple!A27,2),0,"check")

If that doesn't work, you'll need to be a little more specific, maybe provide an example.