i have data pertaining to ships and boats which have different maintenance checks based on time.i have three columns which have time in month, hours and cycles. so when i enter time in one cell in the next cell i want to populate the time remaining for next check. so for one type of repair say "abc" one want to find the time for next check based on the present age. i want to check the time whichever come first. age in months or operation time in hours or number of operations in cycles.
so if the time is given only in hours or months i want to use corresponding formula and the one i am using is
=IF(A13<>"",F13+(365*(D13/12)),IF(B13<>"",F13+F13,F13+C13)). also like in case of avd i want to check which ever time comes first like in given example its age is 60 months and its cycls is 498 so its check will b done baased on cycles as it complete 550 cycles sooner than 120 months. can you please suggest something.
so if the time is given only in hours or months i want to use corresponding formula and the one i am using is
=IF(A13<>"",F13+(365*(D13/12)),IF(B13<>"",F13+F13,F13+C13)). also like in case of avd i want to check which ever time comes first like in given example its age is 60 months and its cycls is 498 so its check will b done baased on cycles as it complete 550 cycles sooner than 120 months. can you please suggest something.
