# Returning a number when using the =IF(D3="100","25","0") [closed]

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