Hi

Can I have some formula help please

If cell E2 says L then if in box G2 I type in the number 245 I want Excel to calculate 245-30 and type the answer 215 into cell G2 when I press the ENTER button on the keyboard.

But

If cell E2 says S I want Excel to calculate 245+30 and type the answer 275 into cell G2 when I press the ENTER button on the keyboard.


Thank you