Rather than typing each OR into the formula as in = if(or(a1="b",a1="j"),1,a1+b1)
I have written the formula like this:
(a) Because I have 30 different values to go into the array
Please Login or Register to view this content.
(b) Because I need to constantly update the values
Having the values in an array would make for much easier editing
BUT it always evaluates to FALSE.
Any ideas on how (or if) the formula can work as I have written it?
Any assistance appreciated.
Thanks.
Why not simply try like this...
BaseData data is the sheet which holds the criteria’s in Column-A. Just use a countif function to check the conditions like the below.
=IF(COUNTIF(BaseData!A:A,A1),1,A1+B1)
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
if you really want to keep the array in code (easier to maintain in a range as sixthsense suggested) you can use
Please Login or Register to view this content.
Josie
if at first you don't succeed try doing it the way your wife told you to
Thanks Sixthsense that is awesome!
Thanks also JosephP, maintaining the range is a much better option!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks