Trending in Formulas and Functions
-
Need help dialing in a grading formula [percentage to letter (100 to A+, 80 to B-, etc.)]
Hey all, This formula works most of the time, but it won't show the letter grade all the time, I think when its close to an in-between number. Any help making it function 100% of the time and not show an empty cell would be appreciated =IF([Week 04/01 Results]5 > 0.96, "A+", IF(AND([Week 04/01 Results]5 >= 0.93, [Week…
-
Countifs formula to count tasks in a range last 7 days to future 7 days
This seemingly simple formula is giving me problems. I want it to count the number of tasks due in the past 7 days through the next 7 days. I am working with the following and getting "#UNPARSEABLE": =COUNTIFS({Owner}, "Joe", {Status}, "In Progress"), {Due}, >= TODAY(-7), {Due}, <= TODAY(+7) I'd appreciate any assistance…
-
If then Help
I have columns with construction bids and the rows are the construction activities with cost. I have 2 years of bids and just want to take the average of the last 6 months of bids for each row of construction activity. =IF([1]4:[101]4 > TODAY(-180), AVG([1]@row:[101]@row), 0) Columns are labeled 1 -101 #INVALID OPERATION