I need help with an =IF statement
Closed
Mel
-
May 21, 2010 at 03:31 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 22, 2010 at 03:00 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 22, 2010 at 03:00 AM
Hello,
I am trying to do an excel spreedsheet with a HR response. In D2 i have an accrual date in E2 i want an if statement that says:
If today is less than d2 and less than 4 years than then the answer is 80 hours, but if the date is less than today and more than 4 years than the answer is 120 hours.
I am trying to do an excel spreedsheet with a HR response. In D2 i have an accrual date in E2 i want an if statement that says:
If today is less than d2 and less than 4 years than then the answer is 80 hours, but if the date is less than today and more than 4 years than the answer is 120 hours.
Related:
- I need help with an =IF statement
- Fenix internet on bank statement - Guide
- Application for bank statement sbi - Guide
- Excel if statement with text - Guide
- Vba case statement with string - Guide
- How many if statements can you nest - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
May 22, 2010 at 03:00 AM
May 22, 2010 at 03:00 AM
say it again. I am confused over more and less part. Could you explain with example