In the formula where you have I12=N12, take out the = sign so that it reads
I12N12. HTH
--
Sincerely, Michael Colvin


"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!!!