loudnoiseman
Board Regular
- Joined
- Dec 31, 2004
- Messages
- 218
- Office Version
- 365
- Platform
- Windows
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
=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