eramirez148
Board Regular
- Joined
- Aug 17, 2022
- Messages
- 54
- Office Version
- 365
- 2021
- 2019
- 2016
- 2013
- 2011
- 2010
- Platform
- Windows
- MacOS
Hello, I need a formula that will deliver results in column "C". I need it to tatste "NO" if there is data in column B. If there is no data in column B and the percentage in column "A" is higher that 20% or lower than -20% the results should say "YES" otherwise the cell should remain empty.
A | B | C |
20.00% | MONDAY | NO |
21.00% | TUESDAY | NO |
10.00% | ||
-1.00% | THURSDAY | NO |
-20.00% | FRIDAY | NO |
-30.00% | SATURDAY | NO |
20.00% | YES | |
21.00% | YES | |
10.00% | ||
-1.00% | ||
-20.00% | YES | |
-30.00% | YES |