I'm trying to create a spreadsheet for a football pool and have need some help with a formula problem
On the first worksheet "Week 1 Spreads" I have a list of the games, spreads, & scores. In column "I" I have simple "IF" formulas to show who won against the spread.
[/IMG]
Here is where I'm having a problem. On another worksheet, I have a list of each persons bets. Below shows that Ryan bet 50pts on New England which is a winner as per the pic above. The formula i am using does not work because in cell I4 on the other worksheet, it has a formula in it not the actual text "New England" so it always comes up as a losing bet and a value of -50. If I go into I4 and write the text "New England" then it works and puts a value of 50 in cell E2.
[/IMG]
Is there a way around this? Please help
On the first worksheet "Week 1 Spreads" I have a list of the games, spreads, & scores. In column "I" I have simple "IF" formulas to show who won against the spread.
Here is where I'm having a problem. On another worksheet, I have a list of each persons bets. Below shows that Ryan bet 50pts on New England which is a winner as per the pic above. The formula i am using does not work because in cell I4 on the other worksheet, it has a formula in it not the actual text "New England" so it always comes up as a losing bet and a value of -50. If I go into I4 and write the text "New England" then it works and puts a value of 50 in cell E2.
Is there a way around this? Please help