Related:
- Nestle fomula nightmare!!
- Print nightmare fix - Guide
- Five nights at freddy's nightmare apk - Download - Horror
- The Apple Vision Pro's virtual keyboard is a nightmare to use according to early adopters - Home - Sound & Image
- "Worst Nightmare," Said the Woman Who Discovered a Foreign Airtag in Her Son's Shoe - Home - Apps & Sites
2 responses
ibraomer
Posts
2
Registration date
Tuesday March 28, 2017
Status
Member
Last seen
March 28, 2017
Mar 28, 2017 at 04:54 PM
Mar 28, 2017 at 04:54 PM
Hi,
Please type the following:
in Column E
E F G
1/1/2016 3/31/2016 Q1
3/31/2016 6/30/2016 Q2
6/30/2016 9/30/2016 Q3
9/30/2016 12/31/2016 Q4
Type list of dates in column A
Then create this formula in Column B
=IF(AND(A2>=$E$2,A2<=$F$2),$G$2,IF(AND(A2>$E$3,A2<=$F$3),$G$3,IF(AND(A2>$E$4,A2<=$F$4),$G$4,$G$5)))
Note:
Cell A2 downwards has the list of dates.
Cell C2 downwards contains the formula
For more details please go ahead
Please type the following:
in Column E
E F G
1/1/2016 3/31/2016 Q1
3/31/2016 6/30/2016 Q2
6/30/2016 9/30/2016 Q3
9/30/2016 12/31/2016 Q4
Type list of dates in column A
Then create this formula in Column B
=IF(AND(A2>=$E$2,A2<=$F$2),$G$2,IF(AND(A2>$E$3,A2<=$F$3),$G$3,IF(AND(A2>$E$4,A2<=$F$4),$G$4,$G$5)))
Note:
Cell A2 downwards has the list of dates.
Cell C2 downwards contains the formula
For more details please go ahead
ibraomer
Posts
2
Registration date
Tuesday March 28, 2017
Status
Member
Last seen
March 28, 2017
Mar 28, 2017 at 05:22 PM
Mar 28, 2017 at 05:22 PM
View the attached excel file at the link below
https://www.dropbox.com/s/zycjgtypblf5u0y/NESTED_IF.xlsx?dl=0
https://www.dropbox.com/s/zycjgtypblf5u0y/NESTED_IF.xlsx?dl=0
Apr 8, 2017 at 05:52 PM
Apr 8, 2017 at 05:52 PM