Excel if function used for different scenarios

thanks for replying to me, I have tried this but it doesn't give me the answer I need. It should be giving me the difference between line 1 (first5characters) and line 3 d28.

the answer should be 3.