multiple values = 1

**nicolastu** · 06-05-2013, 01:35 PM

I am trying to create a formula for this scoring sheet.

If any of D 5 6 7 8 contain a 1 = 1

If any of D 13 14 15 16 contain a 1 = 1

If any of D 20 21 22 23 contain a 1 = 1

If any of D 27 28 29 30 contain a 1 = 1

Thanks
N

MCAA Part A scoring.xls

**tigeravatar** · 06-05-2013, 01:41 PM

nicolastu,

This should work for you:

Please Login or Register  to view this content.

Adjust ranges as needed

**nicolastu** · 06-05-2013, 01:52 PM

is there a way I can get the value rather than TRUE or FALSE to appear?

**tigeravatar** · 06-05-2013, 02:04 PM

Yeah, that's why I edited my post to have --() in the formula. Using that it will convert the boolean values to their 1/0 counterparts

**FDibbins** · 06-05-2013, 02:06 PM

perhaps if would help if you included some (manual?) answers in your workbook?

**nicolastu** · 06-05-2013, 02:10 PM

Thanks that worked perfectly!

Have a good afternoon

**FDibbins** · 06-05-2013, 03:28 PM

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.

Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.