I thought it worked but it didn't.

[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

 

[shg]

Maybe ...

=--OR(N(A1)>0, N(B1)>0)

 

[MrBill11]

This will do it. Entered in C1
=IF(OR(A1>0,B1>0),1,"")

 

[Aladin Akyurek]

Duplicate of:

http://www.mrexcel.com/forum/showthread.php?t=593426

 

[Peter_SSs]

Please do not post the same question multiple times. Questions of a duplicate nature will be locked or deleted, per the Posting Rules (especially points 21-23).

Any bumps, clarifications, or follow-ups should be posted to the linked thread.