Excel Formula Help

Thread replies: 6
Thread images: 2

Anonymous
Excel Formula Help 2016-10-25 15:44:34 Post No. 57232291
[Report] Image search: [Google]

File: scorecard.png (20KB, 705x532px) Image search: [Google]

Excel Formula Help Anonymous 2016-10-25 15:44:34 Post No. 57232291 [Report]

Not sure if right board but here goes

Attempting to set up a score sheet to run on a tablet pc or cell phone instead of using paper based score sheets at my local archery club.

We have a scoring system - the excel screenshot shows the scoring table - where you have up to three shots at the target and the first arrow to hit a scoring zone is the score recorded for that target

Anyway, my limited experience with excel formula is not assisting me - essentially I would like to be able to input the arrow number (1, 2 or 3) and the scoring zone (A, B or C) and have an excel formula calculate the relevant score...

Any assistance here? Or is there a more suitable board?

Anonymous 2016-10-25 15:48:51 Post No.57232333
[Report]

Anonymous 2016-10-25 15:48:51 Post No.57232333 [Report]

VLOOKUP or some shit

Anonymous 2016-10-25 15:52:30 Post No.57232370
[Report] Image search: [Google]

Anonymous 2016-10-25 15:52:30 Post No.57232370 [Report]

File: scorecard2.png (23KB, 709x527px) Image search: [Google]

23KB, 709x527px

Here is a sample scorecard showing the scoring

Anonymous 2016-10-25 15:53:37 Post No.57232381
[Report]

Anonymous 2016-10-25 15:53:37 Post No.57232381 [Report]

>>57232333
How would that work?

Anonymous 2016-10-25 15:56:06 Post No.57232404
[Report]

Anonymous 2016-10-25 15:56:06 Post No.57232404 [Report]

=IF(AND(B3=1;C3="A");20;IF(AND(B3=1;C3="B");18;IF(AND(B3=1;C3="C");16;IF(AND(B3=2;C3="A");14;IF(AND(B3=2;C3="B");12;IF(AND(B3=2;C3="C");10;IF(AND(B3=3;C3="A");8;IF(AND(B3=3;C3="B");6;IF(AND(B3=1;C3="C");4)))

Anonymous 2016-10-25 15:57:28 Post No.57232422
[Report]

Anonymous 2016-10-25 15:57:28 Post No.57232422 [Report]

>>57232404

=IF(AND(B3=1;C3="A");20;IF(AND(B3=1;C3="B");18;IF(AND(B3=1;C3="C");16;IF(AND(B3=2;C3="A");14;IF(AND(B3=2;C3="B");12;IF(AND(B3=2;C3="C");10;IF(AND(B3=3;C3="A");8;IF(AND(B3=3;C3="B");6;IF(AND(B3=1;C3="C");4;0
)))

I'm aware that Imgur.com will stop allowing adult images since 15th of May. I'm taking actions to backup as much data as possible. Read more on this topic here - https://archived.moe/talk/thread/1694/

I'm aware that Imgur.com will stop allowing adult images since 15th of May. I'm taking actions to backup as much data as possible.
Read more on this topic here - https://archived.moe/talk/thread/1694/