Create an IF formula with more than 255 arguments?
I have a formula which is in the format:
However, I've got a lot more values to add (there will be 297 values in total to be exact), and I can only go up to 255 arguments, so how could I add the rest of them?
Please Login or Register to view this content.
That's horrible.
Put your list of values to compare against in a separate range, and check if value exists in that range - something like:
Formula:
Please Login or Register to view this content.
In this case, the list of acceptable values is in cells A1:A297. Adapt to suit.
Edit: further simplified to:Formula:Please Login or Register to view this content.
Last edited by Olly; 07-17-2014 at 07:00 AM.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
Excel 2007 can not handle that # of ifs. Most people would set up a reference table and use a vlookup for something like that.
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks