Need help on formula

%3CLINGO-SUB%20id%3D%22lingo-sub-2218289%22%20slang%3D%22en-US%22%3ENeed%20help%20on%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2218289%22%20slang%3D%22en-US%22%3E%3CUL%3E%3CLI%3EI%20am%20creating%20a%20soft%20copy%20score%20pad%20for%20home%20use%20for%20the%20game%20Phase%2010.%3C%2FLI%3E%3CLI%3EI%20want%20to%20add%20one%20more%20feature%20and%20I'm%20stuck%3A%3C%2FLI%3E%3CLI%3EColumn%20A%20just%20show%20the%20%23%20of%20what%20round%20we%20are%20playing.%3C%2FLI%3E%3C%2FUL%3E%3CP%3EExample%20-%20I%20need%20a%20formula%20where%20if%20a%20%22Y%22%20is%20entered%20on%20Cell%20C3%20-then%20it%20will%20add%20a%20%2B1%20(looking%20at%20the%20number%20in%20Cell%20B3%20and%20putting%20the%20new%20total%20in%20B5).%20If%20an%20%22N%22%20is%20used%20for%20C3%20then%20the%20number%20does%20not%20increase%20and%20B5%20will%20be%20the%20same%20number%20as%20B3.%3CBR%20%2F%3E%3CBR%20%2F%3EThe%20rows(see%20below)%20of%20the%20round%20played%20show%20the%20score%20and%20subtotal%20(%20I%20have%20used%20a%20basic%20formula%20to%20have%20a%20running%20total).%3CBR%20%2F%3EStarting%20with%20Column%20%22B%22%3A%20headings%20are%3A%20B3%3D%20PHASE%20%23%20%2F%20C3%3DMADE%20PHASE%3F%20%22Y%2FN%22%20%2F%26nbsp%3B%20D3%3DName%20-%20then%20repeats%20pattern%20to%20accommodate%20up%20to%206%20players%20using%20columns%20(A%20-%20S)%3C%2FP%3E%3CP%3E%3CBR%20%2F%3ERows%201%20%26amp%3B%202%20contain%20heading%20information%20-%20I%20have%20used%20merged%20and%20center%20on%20some%20cells%3CBR%20%2F%3ERow%203%20is%20where%20current%20phase%20%23%20is%20shown%20and%20the%20score%20for%20that%20round%3CBR%20%2F%3ERow%204%20show%20the%20subtotal%3CBR%20%2F%3EThis%20starts%20over%20on%20row%205%20(%20I%20have%20done%20enough%20rows%20for%2020%20rounds%20(Grand%20total%20is%20on%20row%2042)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2218289%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor
  • I am creating a soft copy score pad for home use for the game Phase 10.
  • I want to add one more feature and I'm stuck:
  • Column A just show the # of what round we are playing.

Example - I need a formula where if a "Y" is entered on Cell C3 -then it will add a +1 (looking at the number in Cell B3 and putting the new total in B5). If an "N" is used for C3 then the number does not increase and B5 will be the same number as B3.

The rows(see below) of the round played show the score and subtotal ( I have used a basic formula to have a running total).
Starting with Column "B": headings are: B3= PHASE # / C3=MADE PHASE? "Y/N" /  D3=Name - then repeats pattern to accommodate up to 6 players using columns (A - S)


Rows 1 & 2 contain heading information - I have used merged and center on some cells
Row 3 is where current phase # is shown and the score for that round
Row 4 show the subtotal
This starts over on row 5 ( I have done enough rows for 20 rounds (Grand total is on row 42)

 

 

1 Reply

@Honey_Tegler 

In B5:

 

=IF(C3="","",IF(C3="Y",B3+1,B3))

 

You can copy B5 to E5, H5, K5 etc., and then to B7, E7, H7, K7, etc. etc.