IF Statement

[mwf3]

I have 3 cells, columns A,B,C. The first 2 cells, A,B should BOTH have a number >0 in order for column C to calculate the formula, otherwise "-".

I started by creating this =IF(A1>1,"-",IF(B1>1,"-",B1/A1)

I am envisioning an "AND" statement to say A1 AND B1 >1

I have tried to figure this out and is probably something very simple.

Thanks in advance for your assistance!

Mark

 

[barry houdini]

Try

=IF((A1>0)*(B1>0),B1/A1,"-")

 

[Crow_23]

=IF(AND(A1>0,B1>0),B1/A1,"-")

What you are looking for?

 

[UniMord]

Use: =IF(SIGN(A1)+SIGN(B1)=2,B1/A1,"-")

 

[mwf3]

Thanks

Thanks Barry, Crow and Unimord, they all worked great!!!