Nested Ifs

[olga6542]

Purchase Items Column B Cell C15 should be:
2 0 it should be 0
between 3-5 0 it should be 1
between 3-5 1 it should be 0
between 6-10 0 it should be 1
between 6-10 1 it should be 1


The answer has to check the input in the purchase items column A and numbers in column B and based on that, return the results in Column C15

Any ideas?

[Pete_UK]

It is not very clear what you want to achieve - please attach a sample Excel workbook and explain in that what the desired outcome should be.

Pete

[olga6542]

C15 output should be the following based on the following criteria
cell A1: between 1-2, cell B1=0, C15 output should be 0
cell A1: between 3-5, Cell B1=0, C15 output should be 1
cell A1: between 3-5, Cell B1=1, C15 output should be 0
cell A1: between 6-10, Cell B1=1, C15 output should be 1
cell A1: between 6-10, Cell B1=0, C15 output should be 1

It's probably going to be array formula

[Pete_UK]

Presumably B1 can only be 0 or 1, but there are still other conditions not covered, i.e.:

cell A1: between 1-2, cell B1=1, C15 output should be ??

And what if A1 is less than 1, or A1 is greater than 10 ?

It's just a multiple IF formula, but need to know all conditions.

Pete

[olga6542]

it's impossible to have value of less than 1, so I wouldn't even put it as a condition. You are not going to have a value more than 10, so I would n't put it as a condition either. I know this is going to be an array formula because it looks at 10 conditions simonteniously.

[Pete_UK]

I don't think you know the meaning of an array formula - this is a nested-IF formula for cell C15:

=IF(A1<=2,IF(B1=0,0,"don't know"),IF(A1<=5,IF(B1=0,1,0),1))

Substitute the appropriate value for "don't know".

Hope this helps.

Pete