Multiple If Statement

[Dolphin123]

I think the formula I need is an 'IF Statement', but not sure. As example, I have data in columns A and B; in column C I require a formula that indicates true if the value in A1 and B1 is 0 (formula refers to 2 columns).

Thank you

A1: 0
B1: 0
C1: true

A1: 3
B1: 0
C1: false

 

[rs2k]

Will this work?

IF(A1=B1,TRUE,FALSE)

HTH
Colin

 

[ron2k]

on C1:
=IF(AND(A1=0,B1=0),"True","False")

Ron

 

[KenWalker]

I suppose you could do this:

=IF(AND(A1=0,B1=0),"true","falsey")

 

[KenWalker]

**** Ron, great minds think alike. lol

 

[Jonmo1]

Unless you might have negative values in either column, and the two add together to make 0....

=NOT(A1+B1)

 

[Dolphin123]

Thank you everyone;surreal how simple it seems once the answer is presented.