Return a Value dependant on a result of two cells

[wysbob]

Good Morning all,

I have a comparison spreadsheet that I am using to crosscheck some information. I have three cells
A1 = Part Number
B1 = In Report 1
C1 = In Report 2

A1 B1 C1
134501 0 1
135670 1 0
965401 1 1

The result that I an trying to achieve is that D1 would show that if the part number is in both B1 and C1 then D1 would say "In Both".

I have tried using if and nested if's but am still new to this type of formula as I get every result but the right one, either Nothing or False etc.

Thanks in advance
Sandy

[canapone]

Hi,

I'm not sure to have undestood:

=IF(B1*C1,"In Both","")

or

=IF(B1&C1="11","In Both","")


Hope it helps

[Glenn Kennedy]

I'm not sure I follow you either, but this might be it:
=IF(AND(B2=1,C2=1),"Both","")