View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
badgereurex badgereurex is offline
external usenet poster
 
Posts: 1
Default 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.