0
I'm working with Google Sheets. I'm trying to get it to choose between two formulas:
=COUNT(L2,M2,N2,O2,P2,Q2,R2)
and
=IF(S2<232,0,7)
In this instance, I'm weighing totals on given days individually vs. the total for the week. L2-R2 correspond to positive values above 43 on each of the days of the week. S2 represents the total numeric value for the week.
If any of L2-R2 has 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) to 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.
Nemesys
Posted 2016-12-26T14:45:46.043
Reputation: 1
1Please read the tags before posting your question. – DavidPostill – 2016-12-26T16:14:45.130
1
You are asking an off-topic question. Please read On-Topic, How do I ask a good question? and What types of questions should I avoid asking?
– DavidPostill – 2016-12-26T16:14:53.760ok so the tags i chose seemed appropriate. one for using formulas in spreadsheet software and another for using google spreadsheets. that pretty well narrows the field a bit. so in dont understand the first comment.as for being on topic, this is regarding the use of a specific piece of software, which falls within the topic guidelines. – Nemesys – 2016-12-26T17:48:59.367
1You still haven't read the tags. "Questions about Google Spreadsheets are off topic and should be asked on webapps.stackexchange.com" – DavidPostill – 2016-12-26T17:50:33.047
then i shall do so there. – Nemesys – 2016-12-26T17:57:19.437
i didnt understand because i am very new to this site and thought choosing the google spreadsheets tag would suffice for help in using google spreadsheets – Nemesys – 2016-12-26T17:59:29.460