Thread: Help with appropriate function

Hello,

Can someone please advise with a Excel problem I have.

What I want to do is:
I have a cell, say A1, with either u (for up) or d (for down) and I have an adjacent cell, B1 with a number in it say 10.

Now in a third cell, C1 I want to add or subtract another number say 5 to the second cell, B1 depending if cell A1 contains a ‘u’ or ‘d’.

So if cell A1 contains ‘u’ then cell B1 would = 10+5

If cell A1 contains ‘d’ then cell B1 would = 10-5

It sounds easy but I am not very good at finding the right function. I think it is ‘IF’ but that returns a value in the formula.

Thanks for any help.

Frank

Thanks for a rapid response and a great answer!

Frank