Need Help with IF in formula.

[bamaisgreat]

In cell H10 i have the following formula =(E10*F10*G10*0.2836)*(F10=0)+(F10*G10) in cell J10 the user will type in the letters CS or SS. I need the formula in H10 to look in this cell and if there is a CS the multipilier need to be 0.2836 if there is a SS the multipiler needs to be 0.3126.

Thanks as always.

Jamey

 

[bamaisgreat]

Thank you all. Worked out Great.