Previous Topic Next Topic

I need help with an =IF statement

Closed
Mel - 21 May 2010 à 15:31
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 22 May 2010 à 03:00
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.

1 response

Réponse 1 / 1
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
22 May 2010 à 03:00
say it again. I am confused over more and less part. Could you explain with example

Similar discussions

Excel - IF function with multiple words
Nick -
user -

14 responses
Excel "IF" function w/ date in test cell
Mike in PA -
salim -

6 responses
Using IF function with dates
dkayeh1 -
RayH -

18 responses