Yes/No if two columns are both Positive or Negative

[sacajamo]

I need to evaluate two columns in which I need a simple outcome. If both numbers in a row are positive or both are negative, output needs to be YES. If one number is positive and the other is negative, output needs to be NO. See example attached. I manually entered the output here but need to figure out the excel formula for several hundred rows. TIA!

10.74	11.35	Yes
-17.43	41.03	No
3.57	39.74	Yes
-70.88	24.92	No
25.62	-56.26	No
11.44	20.42	Yes
-10	-18.39	Yes
14.69	40.73	Yes
-132.2	43.24	No
2.72	-20.19	No
-10.05	42.39	No
32.15	4.98	Yes
17.46	35.12	Yes
58.06	1.26	Yes

 

[Peter_SSs]

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Is this what you mean?

25 02 23.xlsm
	A	B	C
1
2	10.74	11.35	Yes
3	-17.43	41.03	No
4	3.57	39.74	Yes
5	-70.88	24.92	No
6	25.62	-56.26	No
7	11.44	20.42	Yes
8	-10	-18.39	Yes
9	14.69	40.73	Yes
10	-132.2	43.24	No
11	2.72	-20.19	No
12	-10.05	42.39	No
13	32.15	4.98	Yes
14	17.46	35.12	Yes
15	58.06	1.26	Yes
Yes No

Cell Formulas
Range	Formula
C2:C15	C2	=IF(A2*B2>0,"Yes","No")

 

[sacajamo]

Yes that's correct--I was overthinking it. Thank you!

 

[Peter_SSs]

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