If 2 cells values are both 0 show 'No Order=, otherwise show " "

[msritchie2]

A3=0,B3=0 Show No Order if bith A&B values are zero, otherwise blank
Having trouble getting this to work.

=If(A3=0,"No Order",If(A3<>0, " ",If(B3=0,"No Order", If( B3<>0, " " )))

Any Sugestions?

SR

[mikerickson]

To distinguish between 0 and a blank entry, this uses the EXACT function
=IF(AND(EXACT(A3,0),EXACT(B3,0)),"No order","")

[sglife]

heh,try this

=IF(AND(A3=B3,A3*B3=0),"No order","")

[msritchie2]

Thanks for your help...I think we've got it worked out