Great insight! Thanks for Sharing. :-)
Al
--
View this message in context:
http://runtime-revolution.278305.n4.nabble.com/Excel-tip-with-LC-equivalent-Value-comparison-tp4112325p4113595.html
Sent from the Revolution - User mailing list archive at Nabble.com
I have an Excel speadsheet that is kinda self-checking in that 3 cells
display the same value if I have made no data entry errors.
How to determine if cells A1, B1 and C1 are the same value...
Put this in cell D1 to display 'TRUE' or 'FALSE':
=IF(A1=B1,IF(B1=C1,TRUE,FALSE),FALSE)
Bonus feature