Originally Posted by
Martin Barret
Now I've been told that have to consider this:
Value in cell A1 is 15
Value in cell B2 is 0
and now also
Value in cell C3 is 7. C3's value if 0 will be 0, but if ANY digit is in C3, it's value is 2.
I am such an idiot - I don't know how to add this info to the forumula you just gave me, but I figure it goes like:
=IF(OR(A1>0,B2>0,C3),1,0) PLUS IF(OR(C3>0),2,0)
I just need to know how to make it all one single formula.
Thanks so much for your help PEEJAY!!
Martin Barret
Bookmarks