If Formula

[eramirez148]

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

 

[6StringJazzer]

=IF(B2="","",IF(ABS(A2)>=20%,"YES")

Your description says "higher than" and "lower than" but your example shows "higher than or equal to" and "lower than or equal to." My solution matches your example, not your description.

 

[Peter_SSs]

My solution matches your example,

In relation to the 20% I agree, but not in relation to ..

I need it to tatste "NO" if there is data in column B

Sounds like this to me.

22 08 26.xlsm
	A	B	C
1	A	B	C
2	20.00%	MONDAY	NO
3	21.00%	TUESDAY	NO
4	10.00%
5	-1.00%	THURSDAY	NO
6	-20.00%	FRIDAY	NO
7	-30.00%	SATURDAY	NO
8	20.00%		YES
9	21.00%		YES
10	10.00%
11	-1.00%
12	-20.00%		YES
13	-30.00%		YES
YES NO

Cell Formulas
Range	Formula
C2:C13	C2	=IF(B2="",IF(ABS(A2)<20%,"","YES"),"NO")

 

[eramirez148]

That you Peter that worked.

 

[Peter_SSs]

That you Peter that worked.

You're welcome. Thanks for the follow-up.