Forum Discussion
Formulate to filter 3 answers.
Hi All, I am trying to find a way to bring 3 returns on true or false answer. I am looking at date ranges. firstly, I am looking to run a KPI report, so data is based on completed with ta...
=IF(M2="","outstanding",IF(N2<M2,"overdue","on time"))Does this formula return your expected results?
=IF(M2="","outstanding",IF(N2<M2,"overdue","on time"))Does this formula return your expected results?
Thank you, your a star
- Hi Again,
On a pivot table how do you filter between two date ranges?That seems to be a new question. Can you start a new discussion with as much information as possible. Best with a sample file or a screenshot of your file and the expected result. Thank you.
