Hey guys,
I would like to compare cell A1 and B1 to see whether they either match or they are false.
Therefore, =IF(A1=B1, "Match"). But if A1 doesn't equal B1 I would like A3: A9 to be marked as false as well.
I'm sure this is possible, just a heads up cells A3: A9 will already have existing formulas in them. Therefore, I'm hoping for something that will replace these.
Thanks, guys.
You need to tell us what the formulae in A3 to A9 are.
In essence you will need to add this to each of them:
=IF(A$1<>B$1,FALSE,your_formula)
Last edited by AliGW; 08-12-2017 at 11:42 AM.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Hi Aligw,
Thanks for your help so far.
I've just realised that the cells will be going sideways to the right. Therefore, J1: O1 formulas will need to be replaced if A1 doesn't match B1. However, if A1=B1 then I want it to be marked as "Match" and then I want the other formulaes to be untouched. The formula I will be using is below:
=IF(AND(OR(A1="",A2="",A1=A2),A1&A2<>""),"Match","False")
Therefore, would your formulae accompany by mine work? Throughout, J1: O1 the forumales will change. Therefore, J1 will equal the above but K1 will equal =IF(AND(OR(B1="",B2="",B1=B2),B1&B2<>""),"Match","False")
Thanks.
Last edited by AlexShip; 08-12-2017 at 12:11 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks