LinkBack URL
About LinkBacks
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
If 2 cells values are both 0 show 'No Order=, otherwise show " "
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
To distinguish between 0 and a blank entry, this uses the EXACT function
=IF(AND(EXACT(A3,0),EXACT(B3,0)),"No order","")
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
heh,try this
=IF(AND(A3=B3,A3*B3=0),"No order","")
Thanks for your help...I think we've got it worked out
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks