calculate the quotient of two different cells based on the criteria of two cells

[Tacklebuster]

for example, I am trying to find the quotient of two cells but the two cells being calculated might be different based on the criteria of another cell.


in cell I5 and want the quotient of H5/C5 but only if c5 is greater than 0, otherwise I want the quotient calculated between h5/d5. This is because if c5 is 0 then automatically d5 will be greater than 0

Your help is greatly appreciated.

Thanks

 

[jtakw]

Hi,

If you won't have negative #s in C5

=H5/IF(C5,C5,D5)

If you might have negative #s in C5

=H5/IF(C5>0,C5,D5)

 

[AhoyNC]

Try:

Book1
	A	B	C	D				H	I
5			3	5				10	3.333
Sheet1

Cell Formulas
Range	Formula
I5	I5	=H5/IF(C5>0,C5,D5)

 

[Tacklebuster]

Try:

Book1
	A	B	C	D				H	I
5			3	5				10	3.333
Sheet1

Cell Formulas
Range	Formula
I5	I5	=H5/IF(C5>0,C5,D5)

That worked perfectly, thanks so much for your help, you saved me a lot of time. I Googled and searched youtube but none of the answers matched what I needed. Then I saw this forum and registered so I could post my question and the first response solved what I was trying to do. It was so simple and logical, thanks.

Walt