IF Function doubt

[anupambit1797]

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 MID or LAST, I tried to do the below formula in H2, but got #VALUE error, what wrong am I doing here? Could you please share..

Thanks in Advance,

Br,

Anupam

[#2]

=IF(OR(A2="MID",A2="LAST"),F2+G2,"")

@anupambit1797