Multiple if and functoions

[Closed]
Report
-
Posts
1942
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 2, 2021
-
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.


1 reply

Posts
1942
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 2, 2021
145
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