Complicated IF, THEN formula... Please Help!!!!

[addsterf]

I would like to make the if/then formula as follows, but I have no idea how to:

IF column C is equal to "15.5g" THEN divide entire column E by 124 AND IF column C is equal to "5.17g" THEN divide entire column E by 43. I would like these numbers to appear in column F.

Please help!

Thanks

-Adam

 

[Asala42]

Does Column C always contain either 15.5g or 5.17g? What do you want when neither of those conditions are met?

Assuming it's always one or the other:
=E2/IF(C2="15.5g",124,43)

Not applying that assumption:
=IF(C2="15.5g",E2/124,IF(C2="5.17g",E2/43,"-"))