Multiple if and functoions
Closed
Cato
-
7 Aug 2015 à 18:21
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 7 Aug 2015 à 19:12
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 7 Aug 2015 à 19:12
Related:
- Multiple if and functoions
- Mpc hc multiple instances - Guide
- Split excel sheet into multiple files - Guide
- How to delete multiple files on mac - Guide
- Excel multiple lines in one cell - Guide
- Allow multiple downloads chrome - Guide
1 response
Mazzaropi
Posts
1983
Registration date
Monday 16 August 2010
Status
Contributor
Last seen
24 May 2023
147
7 Aug 2015 à 19:12
7 Aug 2015 à 19:12
Cato, Good evening.
Suppose your another cell is C1
Try to use:
=IF(AND(C1>=DATE(1994,1,1),C1<=DATE(1995,12,31)),B2,IF(AND(C1>=DATE(1996,1,1),C1<=DATE(1997,12,31)),B3,""))
Is that what you're looking for?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Suppose your another cell is C1
Try to use:
=IF(AND(C1>=DATE(1994,1,1),C1<=DATE(1995,12,31)),B2,IF(AND(C1>=DATE(1996,1,1),C1<=DATE(1997,12,31)),B3,""))
Is that what you're looking for?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
