Alter the formula for a cell

B

boakley

New Member
Joined
Feb 8, 2018
Messages
36
I have 6 cells that have certain data either in them or populates in them.

The formula that I currently have for the total score (unhidden row 5) is =SUM(G228,I228,K228)

The formula that I have for the total score (hidden row 6) is =IF(AND(G228>=100,I228>=100,K228>=100),SUM(G228,I228,K228),IF(AND(G228<100,I228<100,K228<100),SUM(G228,I228,K228),IF(AND(G228<100,I228>=100,K228>=100),SUM(G228,100,100),IF(AND(G228>=100,I228<100,K228>=100),SUM(100,I228,100),IF(AND(G228>=100,I228>=100,K228<100),SUM(100,100,K228),IF(AND(G228>=100,I228<100,K228<100),SUM(100,I228,K228),IF(AND(G228<100,I228>=100,K228<100),SUM(G228,100,K228),IF(AND(G228<100,I228<100,K228>=100),SUM(G228,I228,100)))))))))

That allowed the event score cells (cells G, I and K) to revert back to "100" if the score in one of the events did not reach the max score of "100", since there is an extended scale that would allow for a score above "100".
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]I[/TD]
[TD]J[/TD]
[TD]K[/TD]
[TD]L[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]PUSH UP REPS[/TD]
[TD]PUSH UP SCORE[/TD]
[TD]SIT UP REPS[/TD]
[TD]SIT UP SCORE[/TD]
[TD]RUN TIME[/TD]
[TD]RUN SCORE[/TD]
[TD]TOTAL SCORE[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]77[/TD]
[TD]100[/TD]
[TD]82[/TD]
[TD]100[/TD]
[TD]1316[/TD]
[TD]100[/TD]
[TD]300[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

My problem is that, when I manually input the number of reps achieved, in cells F5, H5 AND J5, if the number of reps doesn't give a score of "100", all three score cells populate with "100 until something is manually entered into the events reps cells. For example,

If I enter 77 push ups into F5, 100 would populate into cell G5 because 77 push ups equals 100 points. Cells I5 and K5 would remain empty. But if I enter 76 or lower reps into F5, that would give a score of 99 and would make cell G5 populate with the "99" or lower but cells I5 and K5 also populate with "100" for some reason.

I want the score cells (G5, I5 and K5) to remain empty until I manually input some thing their respective reps cells.

I know it has something to do with the formula. Can anyone help?
 

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.
Sort by date Sort by votes
[TABLE="width: 1088"]
<colgroup><col width="64" span="17" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl22, width: 64"] [/TD]
[TD="class: xl22, width: 64"] [/TD]
[TD="class: xl22, width: 64"] [/TD]
[TD="class: xl22, width: 64"] [/TD]
[TD="class: xl22, width: 64"] [/TD]
[TD="class: xl22, width: 64"] [/TD]
[TD="class: xl22, width: 64"] [/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[/TR]
[TR]
[TD="class: xl23, width: 64"] [/TD]
[TD="class: xl23, width: 64"] [/TD]
[TD="class: xl23, width: 64"] [/TD]
[TD="class: xl23, width: 64"] [/TD]
[TD="class: xl23, width: 64"] [/TD]
[TD="class: xl23, width: 64"] [/TD]
[TD="class: xl22"] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl23, width: 64"]PUSH UP REPS[/TD]
[TD="class: xl23, width: 64"]PUSH UP SCORE[/TD]
[TD="class: xl23, width: 64"]SIT UP REPS[/TD]
[TD="class: xl23, width: 64"]SIT UP SCORE[/TD]
[TD="class: xl23, width: 64"]RUN TIME[/TD]
[TD="class: xl23, width: 64"]RUN SCORE[/TD]
[TD="class: xl23, width: 64"]TOTAL SCORE[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 2"]push up reps[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl23, width: 64, align: right"]77[/TD]
[TD="class: xl23, width: 64, align: right"]100[/TD]
[TD="class: xl23, width: 64"] [/TD]
[TD="class: xl23, width: 64"] [/TD]
[TD="class: xl23, width: 64"] [/TD]
[TD="class: xl23, width: 64"] [/TD]
[TD="class: xl23, width: 64"] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="class: xl23, width: 64"] [/TD]
[TD="class: xl23, width: 64"] [/TD]
[TD="class: xl23, width: 64"] [/TD]
[TD="class: xl23, width: 64"] [/TD]
[TD="class: xl23, width: 64"] [/TD]
[TD="class: xl22"] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]20[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]push ups[/TD]
[TD]score[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]40[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]105[/TD]
[TD="class: xl23, width: 64, align: right"]110[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]60[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]60[/TD]
[TD="align: right"]90[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]77[/TD]
[TD="align: right"]100[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]85[/TD]
[TD="align: right"]105[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]95[/TD]
[TD="align: right"]110[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]120[/TD]
[TD="align: right"]115[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 3"]just considering push up reps[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]150[/TD]
[TD="align: right"]120[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 4"]however many push ups achieved[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 4"]score is obtained from ref table on right by[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 3"]=VLOOKUP(A4,mytable,2)[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0
oldbrewer said:
[TABLE="width: 1088"]
<tbody>[TR]
[TD="class: xl22, width: 64"][/TD]
[TD="class: xl22, width: 64"][/TD]
[TD="class: xl22, width: 64"][/TD]
[TD="class: xl22, width: 64"][/TD]
[TD="class: xl22, width: 64"][/TD]
[TD="class: xl22, width: 64"][/TD]
[TD="class: xl22, width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[/TR]
[TR]
[TD="class: xl23, width: 64"][/TD]
[TD="class: xl23, width: 64"][/TD]
[TD="class: xl23, width: 64"][/TD]
[TD="class: xl23, width: 64"][/TD]
[TD="class: xl23, width: 64"][/TD]
[TD="class: xl23, width: 64"][/TD]
[TD="class: xl22"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl23, width: 64"]PUSH UP REPS[/TD]
[TD="class: xl23, width: 64"]PUSH UP SCORE[/TD]
[TD="class: xl23, width: 64"]SIT UP REPS[/TD]
[TD="class: xl23, width: 64"]SIT UP SCORE[/TD]
[TD="class: xl23, width: 64"]RUN TIME[/TD]
[TD="class: xl23, width: 64"]RUN SCORE[/TD]
[TD="class: xl23, width: 64"]TOTAL SCORE[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 2"]push up reps[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl23, width: 64, align: right"]77[/TD]
[TD="class: xl23, width: 64, align: right"]100[/TD]
[TD="class: xl23, width: 64"][/TD]
[TD="class: xl23, width: 64"][/TD]
[TD="class: xl23, width: 64"][/TD]
[TD="class: xl23, width: 64"][/TD]
[TD="class: xl23, width: 64"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="class: xl23, width: 64"][/TD]
[TD="class: xl23, width: 64"][/TD]
[TD="class: xl23, width: 64"][/TD]
[TD="class: xl23, width: 64"][/TD]
[TD="class: xl23, width: 64"][/TD]
[TD="class: xl22"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]20[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]push ups[/TD]
[TD]score[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]40[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]105[/TD]
[TD="class: xl23, width: 64, align: right"]110[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]60[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]60[/TD]
[TD="align: right"]90[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]77[/TD]
[TD="align: right"]100[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]85[/TD]
[TD="align: right"]105[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]95[/TD]
[TD="align: right"]110[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]120[/TD]
[TD="align: right"]115[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 3"]just considering push up reps[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]150[/TD]
[TD="align: right"]120[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 4"]however many push ups achieved[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 4"]score is obtained from ref table on right by[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 3"]=VLOOKUP(A4,mytable,2)[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Click to expand...

I have other sheets with the scoring platform on them. I used INDEX MATCH to get the scores. It works. Its just that with the formula I provides above: =IF(AND(G228>=100,I228>=100,K228>=100),SUM(G228,I228,K228),IF(AND(G228<100,I228<100,K228<100),SUM(G228,I228,K228),IF(AND(G228<100,I228>=100,K228>=100),SUM(G228,100,100),IF(AND(G228>=100,I228<100,K228>=100),SUM(100,I228,100),IF(AND(G228>=100,I228>=100,K228<100),SUM(100,100,K228),IF(AND(G228>=100,I228<100,K228<100),SUM(100,I228,K228),IF(AND(G228<100,I228>=100,K228<100),SUM(G228,100,K228),IF(AND(G228<100,I228<100,K228>=100),SUM(G228,I228,100)))))))))

There is something with this formula that makes the other scoring cells populate with “100” if one of the three scoring cells is less than “100”.
 
Upvote 0
oldbrewer said:
[TABLE="width: 1088"]
<tbody>[TR]
[TD="class: xl22, width: 64"][/TD]
[TD="class: xl22, width: 64"][/TD]
[TD="class: xl22, width: 64"][/TD]
[TD="class: xl22, width: 64"][/TD]
[TD="class: xl22, width: 64"][/TD]
[TD="class: xl22, width: 64"][/TD]
[TD="class: xl22, width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[/TR]
[TR]
[TD="class: xl23, width: 64"][/TD]
[TD="class: xl23, width: 64"][/TD]
[TD="class: xl23, width: 64"][/TD]
[TD="class: xl23, width: 64"][/TD]
[TD="class: xl23, width: 64"][/TD]
[TD="class: xl23, width: 64"][/TD]
[TD="class: xl22"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl23, width: 64"]PUSH UP REPS
[/TD]
[TD="class: xl23, width: 64"]PUSH UP SCORE
[/TD]
[TD="class: xl23, width: 64"]SIT UP REPS
[/TD]
[TD="class: xl23, width: 64"]SIT UP SCORE
[/TD]
[TD="class: xl23, width: 64"]RUN TIME
[/TD]
[TD="class: xl23, width: 64"]RUN SCORE
[/TD]
[TD="class: xl23, width: 64"]TOTAL SCORE
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 2"]push up reps
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl23, width: 64, align: right"]77
[/TD]
[TD="class: xl23, width: 64, align: right"]100
[/TD]
[TD="class: xl23, width: 64"][/TD]
[TD="class: xl23, width: 64"][/TD]
[TD="class: xl23, width: 64"][/TD]
[TD="class: xl23, width: 64"][/TD]
[TD="class: xl23, width: 64"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="class: xl23, width: 64"][/TD]
[TD="class: xl23, width: 64"][/TD]
[TD="class: xl23, width: 64"][/TD]
[TD="class: xl23, width: 64"][/TD]
[TD="class: xl23, width: 64"][/TD]
[TD="class: xl22"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]10
[/TD]
[TD="align: right"]20
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]push ups
[/TD]
[TD]score
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]20
[/TD]
[TD="align: right"]40
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]105
[/TD]
[TD="class: xl23, width: 64, align: right"]110
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]40
[/TD]
[TD="align: right"]60
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]60
[/TD]
[TD="align: right"]90
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]77
[/TD]
[TD="align: right"]100
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]85
[/TD]
[TD="align: right"]105
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]95
[/TD]
[TD="align: right"]110
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]120
[/TD]
[TD="align: right"]115
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 3"]just considering push up reps
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]150
[/TD]
[TD="align: right"]120
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 4"]however many push ups achieved
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 4"]score is obtained from ref table on right by
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 3"]=VLOOKUP(A4,mytable,2)
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Click to expand...

Actually, sorry. I put the wrong formula in here after I looked at it again. The formula that is actually messing it up is:

=IF(AND(SUMPRODUCT(--(J5>=100),--(L5>=100))<1,H5>100),100,H5)
 
Upvote 0
Where is your formula in #4 located? And if different, what formulas are in G5, I5, K5?
 
Upvote 0
dreid1011 said:
Where is your formula in #4 located? And if different, what formulas are in G5, I5, K5?
Click to expand...

EXAMPLE #1
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]I[/TD]
[TD]J[/TD]
[TD]K[/TD]
[TD]L[/TD]
[TD]M[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]GENDER[/TD]
[TD]AGE[/TD]
[TD]PUSH UP REPS[/TD]
[TD]PUSH UP SCORE[/TD]
[TD]SIT UP REPS[/TD]
[TD]SIT UP SCORE[/TD]
[TD]RUN TIME[/TD]
[TD]RUN SCORE[/TD]
[TD]TOTAL SCORE[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]M[/TD]
[TD]31[/TD]
[TD]77[/TD]
[TD]100[/TD]
[TD]82[/TD]
[TD]100[/TD]
[TD]1316[/TD]
[TD]100[/TD]
[TD]300[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

EXAMPLE #2
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]I[/TD]
[TD]J[/TD]
[TD]K[/TD]
[TD]L[/TD]
[TD]M[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]GENDER[/TD]
[TD]AGE[/TD]
[TD]PUSH UP REPS[/TD]
[TD]PUSH UP SCORE[/TD]
[TD]SIT UP REPS[/TD]
[TD]SIT UP SCORE[/TD]
[TD]RUN TIME[/TD]
[TD]RUN SCORE[/TD]
[TD]TOTAL SCORE[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]M[/TD]
[TD]31[/TD]
[TD]75[/TD]
[TD]98[/TD]
[TD][/TD]
[TD]100[/TD]
[TD][/TD]
[TD]100[/TD]
[TD]300[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


Formulas in each Cell:
G4: I enter the data

G5: =G4

H4: =IF(AND(SUMPRODUCT(--(J5>=100),--(L5>=100))<1,H5>100),"100",H5)

H5: =IFERROR(IF(E4="M",INDEX(MALE_PU!$B$2:$AO$121,MATCH(G4,MALE_PU!$A$2:$A$121,0),MATCH(F4,MALE_PU!$B$1:$AO$1,0)),IF(E4="F",INDEX(FEMALE_PU!$B$2:$AO$121,MATCH(G4,FEMALE_PU!$A$2:$A$121,0),MATCH(F4,FEMALE_PU!B$1:AO$1,0)),"")),"")

I4: I enter the data

I5: =I4

J4: =IF(AND(SUMPRODUCT(--(H5>=100),--(L5>=100))<1,J5>100),"100",J5)

J5: =IFERROR(IF(E4="M",INDEX(MALE_SU!$B$2:$AO$121,MATCH(I4,MALE_SU!$A$2:$A$121,0),MATCH(F4,MALE_SU!$B$1:$AO$1,0)),IF(E4="F",INDEX(FEMALE_SU!$B$2:$AO$121,MATCH(I4,FEMALE_SU!$A$2:$A$121,0),MATCH(F4,FEMALE_SU!$B$1:$AO$1,0)),"")),"")

K4: I enter the data

K5: =K4

L4: =IF(AND(SUMPRODUCT(--(H5>=100),--(J5>=100))<1,L5>100),"100",L5)

L5: =IFERROR(IF(E4="M",INDEX(MALE_RUN!$B$2:$AO$812,MATCH(K4,MALE_RUN!$A$2:$A$812,0),MATCH(F4,MALE_RUN!$B$1:$AO$1,0)),IF(E4="F",INDEX(FEMALE_RUN!$B$2:$AO$584,MATCH(K4,FEMALE_RUN!$A$2:$A$584,0),MATCH(F4,FEMALE_RUN!$B$1:$AO$1,0)),"")),"")

M4: =IF(AND(H4>=100,J4>=100,L4>=100),SUM(H4,J4,L4),IF(AND(H4<100,J4<100,L4<100),SUM(H4,J4,L4),IF(AND(H4<100,J4>=100,L4>=100),SUM(H4,100,100),IF(AND(H4>=100,J4<100,L4>=100),SUM(100,J4,100),IF(AND(H4>=100,J4>=100,L4<100),SUM(100,100,L4),IF(AND(H4>=100,J4<100,L4<100),SUM(100,J4,L4),IF(AND(H4<100,J4>=100,L4<100),SUM(H4,100,L4),IF(AND(H4<100,J4<100,L4>=100),SUM(H4,J4,100)))))))))

M5: =IF(AND(H4>=100,J4>=100,L4>=100),SUM(H4,J4,L4),IF(AND(H4<100,J4<100,L4<100),SUM(H4,J4,L4),IF(AND(H4<100,J4>=100,L4>=100),SUM(H4,100,100),IF(AND(H4>=100,J4<100,L4>=100),SUM(100,J4,100),IF(AND(H4>=100,J4>=100,L4<100),SUM(100,100,L4),IF(AND(H4>=100,J4<100,L4<100),SUM(100,J4,L4),IF(AND(H4<100,J4>=100,L4<100),SUM(H4,100,L4),IF(AND(H4<100,J4<100,L4>=100),SUM(H4,J4,100)))))))))


I have other sheets that have been made (male_pu...male_su...male_run...female_pu...female_su...female_run) that I have used with this work book and utilized INDEX MATCH in order to reference the correct score with the corresponding age, gender and reps amount.

In order for anything to populate, the gender has to be entered in the gender column as well as the age.

In example #1 above, for a male that is 31 years old, 77 pushups would get him 100 points. 82 sit ups would get him 100 points and a 1316 run time would get him 100 points. When I enter the data for any of the exercise events (G4, I4 and K4) as long as they got 100 points, everything else would stay blank until I entered the next exercises data.

When I enter the data and they did not achieve 100 points (example #2 ) 75 push ups got him 98 points and then the other score columns automatically populated with 100's even though there was no reps data entered. They would change to the correct score once I input the reps data, but I want them to stay blank until I put something in for the reps data.

I'm thinking that it has to be an issue with my formula in cells H4, J4 and L4. But I'm lost as of this moment. I hope this clarifies. Do you have any idea's?
 
Upvote 0
I am unable to replicate your issue. At the moment, I am manually entering scores in where your INDEX formulas are, and it all seems to work as I think I understand from your post.
 
Upvote 0
dreid1011 said:
I am unable to replicate your issue. At the moment, I am manually entering scores in where your INDEX formulas are, and it all seems to work as I think I understand from your post.
Click to expand...

So your saying that with all the formulas entered the way I have them, and no manually inserted data in cells G4, I4 and K4, everything is blank. And when you enter a reps amount that gives less than 100 pints that populates in H4, nothing populates in J4 and L4 even with no data in I4 and K4? Because it is with mine. I don’t understand this. Lol
 
Last edited:
Upvote 0
You must log in or register to reply here.

Similar threads

J
  • Solved
Using LEFT Function On a Range Instead of A Single Cell Value
Replies
4
Views
127
Fluff
Fluff
E
  • Question Question
How to dynamically update formula in columns
Replies
3
Views
316
eol666
E
F
  • Question Question
Scoresheet creation for a trivia game
Replies
1
Views
346
Rijnsent
Rijnsent
T
  • Question Question
Find highest scorers and return their name
2
Replies
13
Views
252
Peter_SSs
Peter_SSs
Asbestos_Jen
  • Question Question
Compare multiple parameters of samples to reference values (Excel 2007)
Replies
3
Views
392
Asbestos_Jen
Asbestos_Jen

Forum statistics

Threads
1,224,823
Messages
6,181,183
Members
453,020
Latest member
Mohamed Magdi Tawfiq Emam

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top