Matching/Balancing Totals

[hanlonj]

I have a workbook that has a summary page worksheet of linked total
from three different worksheets within the workbook. I have thre
cells of totals that must always match. I need a formula that wil
show me when or if they do not match. Thanks for your help

 

[Guest]

You could use an If formula in an adjacent cell. It would look something like this... =if(not(and(sheet1!b2=sheet2!b2,(sheet3!b2=sheet1!b2)),"OUT OF BALANCE","IN BALANCE". Or if you would prefer, you can use a conditional format that changes color if the totals do not equal

 

[RagDyer]

If your totals were in cells A50, B50, and C50, this will return "True" if
they match, and "False" if they don't:

=AND(A50=B50,A50=C50)

--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

I have a workbook that has a summary page worksheet of linked totals
from three different worksheets within the workbook. I have three
cells of totals that must always match. I need a formula that will
show me when or if they do not match. Thanks for your help!

 

[Peter Atherton]

Try this

=IF(AVERAGE(I5:I7)=I5,"OK","Err")

Regards
Peter

 

[RagDyer]

What happens Peter, if

I5 = 10
I6 = 15
I7 = 5
???
--


Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------


Try this

=IF(AVERAGE(I5:I7)=I5,"OK","Err")

Regards
Peter