Formula Help

[iimmie]

Hi,
I am trying to figure out how to write the following:
if cell a1 or cell b1 has a number greater then zero in it, enter a #1 in cell c1

I appreciate the help once again
Thank you

 

[Aladin Akyurek]

Hi,
I am trying to figure out how to write the following:
if cell a1 or cell b1 has a number greater then zero in it, enter a #1 in cell c1

I appreciate the help once again
Thank you

Something like...

=IF(MIN(A1:B1)>0,1,"")

=(MIN(A1:B1)>0)+0

 

[iimmie]

Actually It didn't work, thank you for trying
Anyone else?

 

[Aladin Akyurek]

Actually It didn't work, thank you for trying
Anyone else?

What result did you get?

And what about the following?

=IF(OR(A1>0,B1>0),1,"")

=IF(OR(N(A1)>0,1,N(B1)>0),1,"")

 

[taurean]

Something like...

=IF(MIN(A1:B1)>0,1,"")

=(MIN(A1:B1)>0)+0

If the OP says: any one of the cells is greater than 0 then it should return 1 so should the formula not be:
=IF(MAX(A1:B1)>0,1,"")

 

[Aladin Akyurek]

If the OP says: any one of the cells is greater than 0 then it should return 1 so should the formula not be:
=IF(MAX(A1:B1)>0,1,"")

Right. Post #4 provides alternatives. Re-capping for iimmie:

=IF(MAX(A1:B1)>0,1,0)

=(MAX(A1:B1)>0)+0

=IF(OR(A1>0,B1>0),1,0)

=OR(A1>0,B1>0)+0

In case A1 and/or B1 might house text values

=IF(OR(N(A1)>0,N(B1)>0),1,0)

The first two would be good enough though.

 

[iimmie]

Thank you to everyone, you all rock!

Right. Post #4 provides alternatives. Re-capping for iimmie:

=IF(MAX(A1:B1)>0,1,0)

=(MAX(A1:B1)>0)+0

=IF(OR(A1>0,B1>0),1,0)

=OR(A1>0,B1>0)+0

In case A1 and/or B1 might house text values

=IF(OR(N(A1)>0,N(B1)>0),1,0)

The first two would be good enough though.