New answers tagged google
0
Given you are multiplying another solution would be to replace the empty cells with 1, provided that wouldn't impact in other aspects
0
I think you can use the Ifs statement
=IFS(B1="",1*B2*B3; B2="", B1*1*B3; B3="", B1*B2*1)
I hope this will help
0
The formula you need is the following:
=NOT(ISBLANK($H3))*(ISBLANK(I3))
Please pay attention to the $ sign in front of H3.
Using the $ (dollar) sign we "lock" the column and the formatting is being applied on the whole row.
You apply the formula on the range I3:AA.
0
Check the Verlander data That is the only one in your example that doesn't calculate the expected value.
The other discrepancy is that you have misunderstood partial innings. X.1 means x & 1/3 innings not x & 1/10 innings. All except Verlander will be correct when you make that adjustment.
Top 50 recent answers are included
