If...it is an If????????

[billyboyuk2000]

Hello All.

Can anyone help with this one!

Trying to return a value based on the following: -

I have 2 numbers to look at but three possible combinations.

If I have two negative numbers then I want my "If" to return nothing.
I also may have 2 positive numbers so again I want it to return nothing.
However, if I have 1 negative and then 1 positive number I want it to return the value of the positive.

Can't quite get it to work!

Can anyone shed any light on this for me? I'm probably using the wrong function!

 

[GlennUK]

What does zero count as, as a sign? For example, if one cell is 24, and the other 0, what's your result? Same for -24 and 0 please?

 

[barry houdini]

If your numbers are in A1 & B1

=IF(A1*B1<0,MAX(A1,B1),"")

 

[billyboyuk2000]

Thank you Mr Houdini

That works a treat.

I got to this: - =IF(D2<0,IF(D6<0,"L","K"),"J") this showed me when I had a negative and a positive etc but not the value.

Thanks again.