Excel Nested Formula
Closed
Numbers
-
Jun 8, 2010 at 12:52 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 8, 2010 at 01:56 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 8, 2010 at 01:56 PM
Related:
- Excel Nested Formula
- Excel grade formula - Guide
- Number to words in excel formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- How many nested if statements in excel - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jun 8, 2010 at 01:56 PM
Jun 8, 2010 at 01:56 PM
How about some thing like this
=IF(AND(A6>=$A$1,D6>11, D6<88, MOD(D6,11)=0),"Got It","Missed You")
=IF(AND(A6>=$A$1,D6>11, D6<88, MOD(D6,11)=0),"Got It","Missed You")