I am using the IF function to return either 25 or 0 and or 100 or 0. These are percentages and for each one returned I need an average at the end. Each time I try to get the average I am getting Zero instead of an average regardless of what is in the cell range. =IF($‘Daily Incentive Tracking’.D3=“y”,“100”,“0”) this is the first one I’m using and =IF(D3=“100”,“25”,“0”) is the second one.
In short I’m trying to use the answers to the IF function in an adjacent cell where those answers are averaged. See below for example of what I want to get
if if if avg
d3 e3 f3 g3
100 0 100 66.66
What I’m getting:
if if if avg
d3 e3 f3 g3
100 0 100 0