If Formula require to calculate No of Days
Closed
Learner
-
May 5, 2010 at 02:03 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 5, 2010 at 08:49 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 5, 2010 at 08:49 AM
Related:
- If Formula require to calculate No of Days
- Skype last seen days ago - Guide
- Number to words in excel formula - Guide
- How to calculate 90 days from date in excel - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Vat calculation formula - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
May 5, 2010 at 05:58 AM
May 5, 2010 at 05:58 AM
LET SAY
DP is in cell A1
DS is in cell B1
PBD is in cell C1
PED is in cell D1
you can write in E1 this
=IF(AND(A1<> "", B1<>"", A1<C1, B1<C1), 0, IF(AND(A1<C1, ISBLANK(B1)), D1-C1, IF(AND(A1>C1, B1>C1), B1-A1, IF(AND(A1>C1, ISBLANK(B1)), D1-A1, "None of 4 conditions"))))
DP is in cell A1
DS is in cell B1
PBD is in cell C1
PED is in cell D1
you can write in E1 this
=IF(AND(A1<> "", B1<>"", A1<C1, B1<C1), 0, IF(AND(A1<C1, ISBLANK(B1)), D1-C1, IF(AND(A1>C1, B1>C1), B1-A1, IF(AND(A1>C1, ISBLANK(B1)), D1-A1, "None of 4 conditions"))))
May 5, 2010 at 07:48 AM
How can I resolve this thing.
Please help
Regards
May 5, 2010 at 08:00 AM
May 5, 2010 at 08:21 AM
Please advice,
Thanks & Regards,
May 5, 2010 at 08:26 AM
May 5, 2010 at 08:37 AM
Regards,