How about

=IF(COUNTIF($A$1:$E$1,A1)=5,"In Balance", "Not In Balance")

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"ExcelStress" wrote in
message ...

What formula would I use if I want to check 5 different cells and if
they are all equal then show In Balance , if not equal show Out of
Balance ?
Any help would be appreciated .
I know the formula to use if only comparing 2 cells , but can't figure
out how to compare more than 2 .

Thank you !


--
ExcelStress