How to: IF FALSE in 2 Cells, Then Obtain Value From 3rd Cell?
 

Hi,
I'd like to create a formula which compares two cells. If both cells
have 'FALSE' values, I'd like for the formula cell to display the
value from a third cell:
I would have thought that
=IF((A10) AND (B10)=FALSE, C10)
would suffice, but no such luck.

Thanks for any feedback.

How to: IF FALSE in 2 Cells, Then Obtain Value From 3rd Cell?
 

Try something like:

=If(And(A10="False",B10="False"),C10,0)

Good Luck.

"badgereurex" wrote:

Hi,
I'd like to create a formula which compares two cells. If both cells
have 'FALSE' values, I'd like for the formula cell to display the
value from a third cell:
I would have thought that
=IF((A10) AND (B10)=FALSE, C10)
would suffice, but no such luck.

Thanks for any feedback.