Re: Excel tip with LC equivalent: Value comparison

2011-11-27 Thread Alejandro Tejada
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

Excel tip with LC equivalent: Value comparison

2011-11-27 Thread FlexibleLearning
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