Hi there,
Hopefully a quick and easy one, how would I insert a range or array of criteria for an IF statement (short of using lookups unless that's the only way?)
Simplifying my formula I have:
=if(e45={"OCT","NOV","DEC"},"YES","NO"}
what would the syntax for an array be in an if statement??
Many thanks in advance,
Mike
One way without using array is
=if(or(e45="Oct",e45="Nov",e45="Dec"),"Yes","No")
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Nice and simple, worked perfectly, thanks very much!
mike, you are just about there...
=IF(OR(E45={"Oct","Nov","Dec"}),"Yes","No")
- i.s.z -
CSE, aka Array aka { }, formulae are confirmed with CONTROL+SHIFT+ENTER.
Replace commas ( , ) with semicolons ( ; ) in formulae, if your locale setting demands.
All good ideas are courtesy resources from this forum as well as others around the web.
- e.o.m -
But you were also close since it should work as:
=if(OR(e45={"OCT","NOV","DEC"}),"YES","NO"}
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks