New answers tagged

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