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

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 need help with an =IF statement
Fenix internet on bank statement - Guide
An if statement nested within another if statement will produce how many possible results? - Guide
Excel if statement - Guide
Application for bank statement sbi - Guide
Vba case statement with string - Guide

1 response

Answer 1 / 1

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
May 22, 2010 at 03:00 AM

say it again. I am confused over more and less part. Could you explain with example

Similar discussions

Removing " false" value in "IF"

Need help to remove FALSE from cell

removing false in excel

Removing "FALSE" from an IF statement with a VLOOKUP

Similar discussions

Subscribe To Our Newsletter!