LinkBack URL
About LinkBacks
I'd go with Tony's suggestion but just in the interests of learning......
Your original formula will work OK with ORs, i.e.
=IF(OR(G2={"Jan","Feb","Mar"}),1,IF(OR(G2={"Apr","May","Jun"}),2,IF(OR(G2={"Jul","Aug","Sep"}),3,4)))
I'd go with Tony's suggestion but just in the interests of learning......
Your original formula will work OK with ORs, i.e.
=IF(OR(G2={"Jan","Feb","Mar"}),1,IF(OR(G2={"Apr","May","Jun"}),2,IF(OR(G2={"Jul","Aug","Sep"}),3,4)))
Audere est facere
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks