krishak77
New member
- Joined
- Jun 21, 2021
- Messages
- 6
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 2008
Hello All,
I need formula for the below criteria
If on the A column having greater than 0 and on B column lesser than 5.30pm, then on C column it should map as Past
If on the A column having Equals to 1 and on B column Greater than 5.30pm, then on C column it should map as Present
If on the A column having Equals to 0 and on B column lesser than 5.30pm, then on C column it should map as Present
If on the A column having Equals to 0 and on B column Greater than 5.30pm, then on C column it should map as Future.
Below are the few examples which i need like below.
Thank you in advance.
Regards,
Anantha
I need formula for the below criteria
If on the A column having greater than 0 and on B column lesser than 5.30pm, then on C column it should map as Past
If on the A column having Equals to 1 and on B column Greater than 5.30pm, then on C column it should map as Present
If on the A column having Equals to 0 and on B column lesser than 5.30pm, then on C column it should map as Present
If on the A column having Equals to 0 and on B column Greater than 5.30pm, then on C column it should map as Future.
Below are the few examples which i need like below.
Number | Time | Status |
1 | 4.30pm | Past |
1 | 5.30pm | Past |
1 | 6.30pm | Present |
0 | 5.30pm | Present |
0 | 5.40pm | Future |
Thank you in advance.
Regards,
Anantha