How are nested IF formulas that include calculations organised?

Hi,
I am attempting a nested IF formula that includes calculations for Excel Mac 2011. I’ve spent half a day trying multiple methods but can’t seem to nail it. I wonder if someone could let me know if what I’m trying to do is possible and point me in the right direction.

The formula is in cell K3, MT5 sheet, here is the description…

If F3=0 then show empty cell, If E3=“L” then G3-H3, otherwise H3-G3, If G3 > 0 then multiply the answer by 10000, If G3 > 10 then multiply the answer by 100, If G3 > 900 then multiply the answer by 10.

This is my best attempt with the IF function
=IF(F3=0,"",IF(E3="L",G3-H3,H3-G3),IF(G3>0,*10000),IF(G3>10,*100),IF(G3>900,*10))

Here’s my attempt using IF with AND (with the initial blank cell part removed):
=IF(AND(G3>0,E3=“L”),G3-H3*10000,H3-G3*10000),IF(AND(G3>10,E3=“L”),G3-H3*100,H3-G3*100),IF(AND(G3>900,E3=“L”),G3-H3*10,H3-G3*10)
Unfortunately this results in a #NAME error.

I’d be most grateful if someone could help me out with this one.

Regards

Awesome, that works superbly. I'll enjoy figuring out how you did it. Thanks