Hello, community. I'm seeking help to solve the following formula and would greatly appreciate any and all solutions and suggestions.
Need to solve:
=IF(SUM(G60:G79)<2,"DAY",IF(AND(SUM(G60:G79)>1,SUM(G60:G79)<6,="WEEK",IF(SUM(G60:G79)>5,"MONTH")),0))
First and third IFs function properly individually:
=IF(SUM(G60:G79)<2,"DAY",0)
=IF(SUM(G60:G79)>5,"MONTH",0)
Second IF returns FALSE regardless of tweaking:
=IF(AND(SUM(G60:G79)>1,SUM(G60:G79)<6,"WEEK"),0)
Cells G60 thru G79 contain varying quantities of days. The purpose of this intended formula is to determine whether the rounded up sum of cells G60 thru G79 equals a 1 or "DAY", 5 or "WEEK", or 6+ or "MONTH". As shown above, I'm able to successfully produce the first and third IFs as standalone formulas, so I suspect that the FALSE result stems from an error in the second IF containing the nested AND. As a note, I'm aware of the IFS function and am experiencing similar if not the same challenge as my attempted IF formula. I'm also aware of the SWITCH alternative to IFS/multiple IFs, but have only seen it suggested as a solution to simplifying multiple entries from a list or table of text or number values and not from a SUM.
That's all the best information I can think of to include, but let me know if any more is needed to solve my issue.
Thanks in advance!
Bookmarks