jamiguel77
Active Member
- Joined
- Feb 14, 2006
- Messages
- 378
- Office Version
- 2016
- 2010
- 2007
- Platform
- Windows
- Web
Based on Dates, how to know the discount if Yes or No column?
the first cell(C11) would be the answer 9%
thanks
Desde | Hasta | Yes | No | |
27/02/2011 | 26/02/2013 | 13% | 10% | |
26/02/2013 | 26/02/2015 | 11% | 8% | |
26/02/2015 | 25/02/2017 | 9% | 7% | |
25/02/2017 | 25/02/2019 | 7% | 4% | |
25/02/2019 | more… | 1% | 2% | |
15/03/2016 | Yes | |||
05/04/2014 | No | |||
24/04/2012 | No | |||
11/05/2019 | Yes | |||
15/04/2012 | No | |||
the first cell(C11) would be the answer 9%
thanks