Combing IF and Round with an excel check formula

rlc

New Member
Joined
Feb 11, 2010
Messages
41
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

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,138
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

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
51,507
Office Version
365
Platform
Windows
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.
 

Forum statistics

Threads
1,082,548
Messages
5,366,227
Members
400,880
Latest member
dwb

Some videos you may like

This Week's Hot Topics

Top