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

loudnoiseman

Board Regular
Joined
Dec 31, 2004
Messages
196
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

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,318
Office Version
  1. 365
Platform
  1. Windows
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
Joined
Jan 13, 2005
Messages
5,219
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
Joined
Mar 17, 2004
Messages
19,958
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
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
Joined
Dec 31, 2004
Messages
196
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 (y)
 

Forum statistics

Threads
1,147,675
Messages
5,742,546
Members
423,737
Latest member
tom_xls

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top