Multiple if and functoions
Closed
Cato
-
Aug 7, 2015 at 06:21 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Aug 7, 2015 at 07:12 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Aug 7, 2015 at 07:12 PM
Hello,
I'm trying to write a function for a cell which refers to a date in another cell - which if it is between 01/01/1994 and 31/12/1995 the cell will read cellB2, but if the date is between 01/01/1996 and 31/12/1997 it will read Cell B3
Thanks for any help.
I'm trying to write a function for a cell which refers to a date in another cell - which if it is between 01/01/1994 and 31/12/1995 the cell will read cellB2, but if the date is between 01/01/1996 and 31/12/1997 it will read Cell B3
Thanks for any help.
Related:
- Multiple if and functoions
- How to lasso multiple objects in photoshop - Guide
- Allow multiple downloads chrome - Guide
- How to delete multiple files on mac - Guide
- How to rotate multiple pictures at once windows 10 - Guide
- How to open multiple media player windows - Guide
1 response
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Aug 7, 2015 at 07:12 PM
Aug 7, 2015 at 07:12 PM
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
