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

#### loudnoiseman

##### Board Regular
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

### Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

#### Norie

##### Well-known Member
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

##### Well-known Member
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

##### MrExcel MVP
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

##### Board Regular
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

Replies
2
Views
959
Replies
0
Views
489
Replies
1
Views
989
Replies
2
Views
753
Replies
2
Views
174

1,181,993
Messages
5,933,145
Members
436,881
Latest member
CMScons

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back