I have 3 conditions set with checkboxes, I would like to generate a number between 1 and 7 which would show what combination of checkboxes have been checked. Is there a simpler way, rather than use of If statements to do this?
Combinations selected
1 - 1
2 - 2
3 - 3
4 - 1 & 2
5 - 1 & 3
6 - 2 & 3
7 -1 & 2 & 3
Can the order in which the checkboxes add up to 7 be changed? You could just use Binary for this if so.
Checkboxes A B and C
Logic:
If A is checked, 1
Please Login or Register to view this content.
if B is checked, 2
If C is checked, 4
=SUM(ABC)
Something like...and I may be wrong on that variable, I'm bad at arrays
Please Login or Register to view this content.
Last edited by Speshul; 11-10-2014 at 04:58 PM.
You should hit F5, because chances are I've edited this post at least 5 times.
Example of Array Formulas
Click the * below on any post that helped you.Originally Posted by Jacc
Well, I did use a mess of IFs, VLOOKUP and IFERROR.
Formula:
Please Login or Register to view this content.
Another way using LOOKUP
Formula:Please Login or Register to view this content.
Last edited by newdoverman; 11-10-2014 at 05:29 PM.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
Thanks for the approaches, I'll give them a try, and see which one works best for my application.
Al
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks