Allowing for Zeroes in Calculating a Variance to Forecast

[AllyOops]

Hi Everybody,

There are Three Scenarios where a variance is being reported as zero, Scenario A the forecast is zero or Scenario B the actuals are zero and Scenario C where both are zero. This works fine!

I am calculating a comment where 95-100% Accuracy is a Meets Forecast, >100% Exceeds Forecast and >0% but less than 95% is a Miss. I am trying to add a condition to allow for the variable reasons for a zero.

The following works to give me a distinction between no forecast and a missed forecast:
=IF(AND(Q16=0,P16>0),"Missed","")

but when I nest it into the full nested if statement the answer Missed flips to "Not Forecast"
=IF(Q16>1,"Exceed",IF(Q16>0.95,"Meet",IF(AND(Q17=0,P17>0),"Missed","Not Forecast")))

Is this an order of operations problem?

 

[AllyOops]

This is where P16 = Forecast and Q16 = Sales!