=> Formula

[Guest]

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

 

[Guest]

In the formula where you have I12>=N12, take out the = sign so that it reads
I12>N12. HTH

 

[Guest]

Just remove the equals sign:

=if(l12>N12,"Yes","No")

= Means greater than or equal to, while > means just greater than.

HTH,
Elkar

 

[Guest]

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").