= Formula
 

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

= Formula
 

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

= Formula
 

Just remove the equals sign:

=if(l12N12,"Yes","No")

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

HTH,
Elkar

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

= Formula
 

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