Hi
I have a spreadsheet that is updated daily, it is used to track hours/kms of trucks and when the last service was completed.
I need a formula added into column G (HRS truck service due) that will do the following
- if column E "Last service type" equals "A", add D2(HR's/KMs till truck service due)+250
- if column E is "B", add D2+125
- if column E is "C", add D2+125
For example in the attached worksheet G2 will equal 29,398. I want a formula that will add these values automatically. I did try the IF function (and nesting IF Functions) and I don't think it was correct
Thank you!![]()
Bookmarks