Multiple IF Conditions based on Text in a cell

[naga]

Hi,

I have a file in which F9 has the value subtracted from E9 - D9.
C9 has a value either "M" or "SF"
Cell H9 has the following formula

H9=IF((F9>G9),(F9-G9)*1,IF((F9<G9),(G9-F9)*2,0))

I need the formula if C9 = "M" then the above formula should be applied.
If C9 = "SF" then the following formula should be implemented.

H9=IF((F9>G9),(F9-G9)*1,IF((F9<G9),(G9-F9)*5,0))

I tried AND and OR logics but couldn't sort it out.
Somebody please guide me.
Thanks in advance.

I have attached my file.

[Ace_XL]

Maybe..
=IF(F9>G9,(F9-G9)*1,IF(F9<G9,(G9-F9)*IF(C9="M",2,IF(C9="SF",5,0)),0))

[naga]

Hi,

Ace thanks for your reply and help.
This is what I was looking for exactly.

Thanks a lot Sir.