=IF(S2>=99,S2,"") - How to modify so over 101 i

[loudnoiseman]

Hello,

=IF(S2>=99,S2,"") formula in T2 is blank if S2 is below 99 but what modification can be made to make T2 blank only if below 99 OR above 101 as well?

("S" column is a percentage of my goal and I just want to see where 100 percent has been achieved though percentage often runs far over so I want to quick visually scan for row where goal is met).

Thank You!!

Ted

 

[Norie]

Maybe something like this:

=IF(AND(S2>=99,S2<=101),S2,"")

BTW have you considered using Conditional formatting to highlight the rows where the goal is met.

 

[daniels012]

Re: =IF(S2>=99,S2,"") - How to modify so over 1

try this
=IF(OR(H21<=99,H21>101),H21,"")

or
=if(h21=100,"",h21)
if 100 is the only number you want not displayed

Hope this helps,
Michael

 

[Scott Huish]

Re: =IF(S2>=99,S2,"") - How to modify so over 1

You only want to see where it is 100?

=IF(S2=100,100,"")

 

[loudnoiseman]

Re: =IF(S2>=99,S2,"") - How to modify so over 1

Thanks Norie, your solution works well! The percentage is rarely in whole numbers so I can't just search for 100, so now with your formula I get a small batch of #'s between 99-101 which is good... Thanks again All