I need a formula that will choose between two formulas.
In this instance, I'm weighing totals on given days individually vs. the total for the week. L2-R2 correspond to a numeric value above 43 on each of the days of the week. S2 represents the total numeric value for the week.
If any of L2-R2 have a numeric value above 43, 1 point is added in the first formula, contained in CELL V and that total is the point value for the week.
However if the total numeric value for the week exceeds 232 for the week, as indicated in the second formula, the point value for the week is 7.
I want a formula that decides that if
=IF(S2<232,0,7) returns true, have that formula show its output. if it returns false, I want
=COUNT(L2,M2,N2,O2,P2,Q2,R2) show its output.
As it stands right now, I have each formula in its own CELL and have to visually compare, which is tedious, given the sheer number of times I have to compare.