| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How would I edit this formula to do what I want?
As far as I can see, the formula you posted appears to already do what you
are asking for. Perhaps if you describe what you want for each possible X4, Y4 combination, that might helps us to be able to answer your question. -- Rick (MVP - Excel) "Danny Boy" wrote in message ... I'd like to modify this formula so that the NO Flag appears if a date is missing in BOTH X4 and Y4. The current formula generates the NO flag, if a date is missing in either X4 or Y4. Any suggestions? =IF(COUNT(X4,Y4)=2,IF(TODAY()Y4,"Yes",""),"No") |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help to edit a formula | Excel Worksheet Functions | |||
| how to edit formula without changing formula of each cell | Excel Worksheet Functions | |||
| fx instead of "=" on formula edit bar | Excel Discussion (Misc queries) | |||
| i edit a formula (excel) then it displays formula not answer | Excel Discussion (Misc queries) | |||
| = (edit formula) | Excel Discussion (Misc queries) | |||
Threaded Mode
