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
Bookmarks