# Need help - IF Formula

1. ## Need help - IF Formula

I am doing a spreadsheet to keep track of gambling wins/losses in different sports. I need help with a formula, what i want is this :

If the outcome box says "WIN" the profit/loss cell will then times K3 and J3 together and then minus J3, If the outcome box says "LOSS" I want the profit loss column to show -J3 spreadsheet.jpg

Thanks if anyone can help

2. ## Re: Help needed

try this
=if(L3="WIN";(K3+J3)-J3;if(L3="LOSS";-J3;"""))

4. ## Re: Help needed

This will work for cell M3.
Formula:
`Please Login or Register  to view this content.`

for cell E3:
Formula:
`Please Login or Register  to view this content.`

5. ## Re: Help needed

Thanks alot Duncan! problem solved what a great forum this is

6. ## Re: Help needed

The formula for E3 only seems to patrially work, If the stake is 1 it says profit is 0, it seems to be minusing 2.05 regardless of the stake

7. ## Re: Help needed

Sorry, instead of B3*C3-C3,-C3, it should be B3*C3-B3,-B3

My mistake!

Don't forget to click the star, and rename the post according to the forum rules.

Regards

8. ## Re: Help needed

benallen,

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request.

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

9. ## Re: Need help - IF Formula

Your title still does not comply with forum rules. I have changed it for you.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1