If, then statement in Excel
Solved/Closed
Related:
- If, then statement in Excel
- Fenix internet on bank statement - Guide
- Excel if statement - Guide
- Number to words in excel - Guide
- Marksheet in excel - Guide
- Gif in excel - Guide
3 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Feb 18, 2010 at 06:57 AM
Feb 18, 2010 at 06:57 AM
Assumptions
1. A1 is a date
2. If a1 or b1 is blank, then nothing is to be seen in c1
3. If b1 is neither Leave or Pass nor blank, then show in c1 same date as a1
Put this in c1 and format the c1 to be a date in the format that you desire/
=IF(OR(A1="",B1=""),"",A1+IF(B1="Leave",21,IF(B1="Pass",10,0)))
1. A1 is a date
2. If a1 or b1 is blank, then nothing is to be seen in c1
3. If b1 is neither Leave or Pass nor blank, then show in c1 same date as a1
Put this in c1 and format the c1 to be a date in the format that you desire/
=IF(OR(A1="",B1=""),"",A1+IF(B1="Leave",21,IF(B1="Pass",10,0)))
YES!! It worked. Thank you rizvisa1. You don't know how much time you have saved a Soldier for the next 10 months.
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Feb 18, 2010 at 09:27 AM
Feb 18, 2010 at 09:27 AM
Glad to know that I could help some one. Stay safe.