I have a formula numeric field [score] that is assigning a value to checkboxes ( [meets], [partial meets], and [does not meet] ) and then calculating the average of those assigned values. I want to be able to a N/A to each question, and have the formula numeric field calculate the average of only those that are applicable. Is there any way to do this? Thanks

Currently my formula looks like this:

var number Q1 = If([Q1-meets], 1, [Q1-partial meets], 0.6, 0.3);

var number Q2 = If([Q2-meets], 1, [Q2-partial meets], 0.6, 0.3);

var number Q3 = If([Q3-meets], 1, [Q3-partial meets], 0.6, 0.3);

var number Q4 = If([Q4-meets], 1, [Q4-partial meets], 0.6, 0.3);

($Q1 + $Q2 + $Q3 + $Q4)/4

Currently my formula looks like this:

var number Q1 = If([Q1-meets], 1, [Q1-partial meets], 0.6, 0.3);

var number Q2 = If([Q2-meets], 1, [Q2-partial meets], 0.6, 0.3);

var number Q3 = If([Q3-meets], 1, [Q3-partial meets], 0.6, 0.3);

var number Q4 = If([Q4-meets], 1, [Q4-partial meets], 0.6, 0.3);

($Q1 + $Q2 + $Q3 + $Q4)/4