Excel Formula Question

[vharp91]

I need a formula that will return a "yes" in column Q if there is a number present in cells in column H AND column I that is greater than zero. Essentially, I want to see if there has been data present in the prior 2 quarters. If the number in either cell of column H and I is greater than zero, but there is a zero in the other column, I want to return a "no" in the cell in column Q. If both cells of column H and I contain a zero, then I want it to return a "no" in the cell of column Q. Essentially, the formula would only return a "yes" if there are numbers larger than zero in both cells of column H and I.

 

[JGordon11]

Book1
	H	I	J
1	3Q2022	2Q2022	Historical
2	0	5	no
3	2	6	yes
4	4	0	no
5	0	0	no
6	0	0	no
7	0	0	no
8	5	7	yes
Sheet1

Cell Formulas
Range	Formula
J2:J8	J2	=IF(H2*I2,"yes","no")

 

[RaviWildcat]

Wait a moment! I was going to provide an answer that was a lot wordier and a lot less elegant!

Will that always work? (If (expression<>0 then true otherwise no? )

 

[JGordon11]

if expression is something that can be evaluated as a number <>0

Book1
	A	B
1	-1.5	TRUE
2	-1	TRUE
3	0	FALSE
4		FALSE
5	1	TRUE
6	1.5	TRUE
Sheet1

Cell Formulas
Range	Formula
B1:B6	B1	=IF(A1,TRUE,FALSE)

 

[RaviWildcat]

Wow! What a Time Saver!

 

[bebo021999]

If column Q in image was exactly your manual output (There is 1 number>0 at least), try:
=IF(OR(H3>0,I3>0),"Yes","No")