If Formula require to calculate No of Days
Closed
Learner
-
5 May 2010 à 02:03
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 5 May 2010 à 08:49
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 5 May 2010 à 08:49
1 response
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
5 May 2010 à 05:58
5 May 2010 à 05:58
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"))))
5 May 2010 à 07:48
How can I resolve this thing.
Please help
Regards
5 May 2010 à 08:00
5 May 2010 à 08:21
Please advice,
Thanks & Regards,
5 May 2010 à 08:26
5 May 2010 à 08:37
Regards,