Nested IF function to pull back text based on dates?
-
I need a nested IF function in Excel - I would like it to report back with a status based on what columns have dates. If column B contains a date, then display "Created", ...show more
-
Answer:
Try =IF(B1>1,"Created",IF(C1>1,"Delivered",I... Change B1 to the cell in column B, C1 to the cell column C, and D1 to the cell in column D You may need to do it in reverse order to prevent the cell showing an error, ie accepted first and created last
YUVAUO3MCRNVB2MGV6SRBRWJQI at Yahoo! Answers Visit the source
Related Q & A:
- How to fit the model for crossed and nested design using lme function in R?Best solution by Cross Validated
- What is pull back rally in stock market?Best solution by en.mimi.hu
- How long does it take to heal when you pull your back?Best solution by Yahoo! Answers
- Do guys text back just to be polite?Best solution by Yahoo! Answers
- How to make an airsoft gun easier to cock/pull back?Best solution by Yahoo! Answers
Just Added Q & A:
- How many active mobile subscribers are there in China?Best solution by Quora
- How to find the right vacation?Best solution by bookit.com
- How To Make Your Own Primer?Best solution by thekrazycouponlady.com
- How do you get the domain & range?Best solution by ChaCha
- How do you open pop up blockers?Best solution by Yahoo! Answers
For every problem there is a solution! Proved by Solucija.
-
Got an issue and looking for advice?
-
Ask Solucija to search every corner of the Web for help.
-
Get workable solutions and helpful tips in a moment.
Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.