Dear Moderators
Many thanks for your support in providing the necessary help in constructing the automated files.
I am in middle of constructing a formula please see the attached file:
Need help in the following criteria:
1 If E7 is "FD" then, the H7 can exceeds maximum limit of 80 then in cell I7 it should give result of only excess km will be there
2 In the same way If E7 is "HD" then, the H7 exceeds maximum limit of 40 then in cell I7 it should give result of only excess km
3 In the same way If E7 is "FD" then, the M7 can show the extra hrs if it is >8 hrs
4 In the same way If E7 is "HD" then, the M7 can show the extra hrs if it is >4 hrs
Appreciate you earliest help in this regards
Amul
Bookmarks