Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
help with Excel formulas?
I know there's a way to do this, but I can't figure it out. I need a logic formula that will result in the entry of a symbol, letter, or number into a cell dependent upon whether data has been entered into another cell. In other words, if there is a date entered into cell D8, then put a check mark or an "x" into cell D9. I hope this makes sense.
1 Answer
- puakaLv 510 years agoFavorite Answer
Assuming A1 is being evaluated
=IF(ISNA(MATCH(CELL("format",A1),
{"D1","D2","D3","D4","D5"},FALSE)),
"Not Date", "Is Date")
