View Single Post
 
Old 11-07-2016, 07:12 PM
ExcelPatient ExcelPatient is offline Mac OS X Office 2008 for Mac
Novice
 
Join Date: Nov 2016
Posts: 3
ExcelPatient is on a distinguished road
Default New wrinkle

Awesome. Very helpful.

Now, a new issue.

(Q5) is reading an error because (Q4) is a formula that calculates the average of (Q1-Q3) and its result contains a number to the millionth, which the VLookup in (Q5) cannot find. Obviously, I cannot include all possible divisions between 1 and 5 inside (A8:B21).

(Q4) formula reads: =IF(COUNT(Q1:Q3)>0,AVERAGE(Q1:Q3),"")

See picture, below.

Screen Shot 2016-11-07 at 8.01.33 PM.png
Reply With Quote