| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
OR options in IF statement
I'm trying to look at two cells, and if either has a date in it I want that
date in a third cell (where the formula is). This formula works: =IF(COUNT(tab!$AF6)=1,MAX(tab!$AF6),"") for checking one cell, but I also want to check (tab!AQ6) for a date. Any suggestions? Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| tools options view window options | Excel Discussion (Misc queries) | |||
| Send mail with outlook message options-Delivery OptionS | Excel Programming | |||
| Working with options from within Tools Options clears the Clipboar | Excel Programming | |||
| How to diasble the 'Tools - Options - View - Comments' options? | Excel Programming | |||
| Can an IF statement be used for 3 options? | Excel Discussion (Misc queries) | |||
Threaded Mode
