Returning Values for 2 Non-Adjacent Cells

Hi there. I'm a very weak forumula creator/user. Love some help here.

Value in cell A1 is 15
Value in cell B2 is 0

What forumla can be given that returns a value of 1 if both A1 & B2 OR just A1 (or just B2) are occupied by numerical data? If both A1 or B2 contain a value of 0, then the forumula cell must return 0 as well.

This forumla will repeat for up to 100 individuals down a list.

I appreciate any help from the experts.

Thanks.
Martin Barret

type the following formula into c1 or c2
=IF(OR(A1>0,B2>0),1,0)

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

you will get a circular referance ERROR if you try to check c3 value and then try to alter c3 based on this check,
so you will need to re-think how you check these 3 conditions and where your going to put the result

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

Hi Martin

you cannot get two results from a single formula
what you want is
if A1 or B2 is greater than 0 then show 1 and C3 if greater than 0, show 2
you cannot get both results with single formula.
you need two formulas to check for your criteria.

explaing more about your data that what exactly you want to do so that other options could be considered.

Regards.

Thanks so much.

I've entered the formulas and they work nicely together/side by each.

I then sum the results and voila - a great spreadsheet.

Take care - I'm sure I'll be posting again soon!

Martin Barret