My guess is that you have a rounding problem. 80.4% is OVER your 80% policy,
but if your not showing the decimals, it would look like 80% even.

Try this. =if(round(l12,2)=N12,"Yes","No").

"nolechik" wrote:

I have a report I created to tell me if a certain percentage is over policy.
I set the formula to automatically indicate on the spreadsheet if a category
is over a set limit. For example our policy limit is 80% and the item is at
82% then it would indicate yes, as being over policy. But when the item is
the same as the limit 80% it still indicates yes as being over policy...I
need it to indicate no when this happens.... here is the formula I have in
there.....=if(l12=N12,"Yes","No").

HELP!!!