Hi, I am in need of some help with what I thought was a simple formulae.
I have attached a sample sheet.
I need cell G3 to display "FALSE" if B3=E3 AND C3=F3. I have entered a formulae, but it does not seem to work unless I double click on the formulae and then click the green tick.
Can someone please let me know why or suggest an alternative solution please.
Many thanks
In G3
=IF(AND(B3=E3,C3=F3),FALSE,"")
Copy down
Life's a spreadsheet, Excel!
Say thanks, Click *
Your formula is OK but the file is set to manual calculation.
Set it to automatic calculation: Formulas tab>Calculation>Calculation Options>Automatic
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Excellent, many thanks to you both.
You're welcome. We appreciate the feedback!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks