IF Function doubt

Dear Experts,                       I have a data like below(attached sheet as well):- Column "B" so(Segment Offset) is calculated as the sum of Column "F" and "G" only when Column "A" is either M...