| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Obtain a Year to Date result without all cells of data being fille | Excel Worksheet Functions | |||
| VBA always creates linked chart even when using PasteExcelTable False, False, False in Office 2007 | Excel Programming | |||
| highlight cells to obtain total without using formula? | Excel Discussion (Misc queries) | |||
| How to obtain Cell Name | Excel Programming | |||
| How to obtain the shortest range that encloses all the non empty cells? | Excel Programming | |||
Linear Mode
