=> Formula

[nolechik]

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

[Michael]

In the formula where you have I12>=N12, take out the = sign so that it reads
I12>N12. 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!!!

[Elkar]

Just remove the equals sign:

=if(l12>N12,"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!!!

[Jonathan Cooper]

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