Thread: Multiple IF formulas

Here's what I'm trying to do:

If column H is BLANK, then I want column J2 to equal the value in B2
If column H is "L", then I want column J2 to equal B2+F2

I can't seem to figure it out---anyone out there know how to do this? The "L" comes from a Win/Loss column, but I don't want to have to type the W's.

Any help would be appreciated! Thanks in advance!

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

Try

=IF(H2="",B2,IF(H2="L",B2+F2,""))

Not sure thought what you mean by: but I don't want to have to type the W's.

Are you adding cells or concatenating cells?