I mainly use Excel for gambling spreadsheets. I was wondering if someone can help me simplify my spreadsheet. Say I have the word "Win" in column B. Is there a formula I can write in another column where it automatically upgrades the win to +100 in a column. Or -110 if I type in "Loss."
Thanks in advance and more newb questions to come.
