I have an estimated win probability for the NBA home team and want to convert it to a point spread, what is the formula for this?
Thanks in advance.
Posters' Poll: Top Sportsbooks

Best Sportsbooks List
SBR TopRated Sportsbooks


#1 5Dimes (SBR rating A+)  675 Pts  #1 Bookmaker  SBR rating A+  Review  
#2 Heritage Sports (SBR rating A+)  665 Pts  #2 5Dimes  SBR rating A+  Review  
#3 Bookmaker (SBR rating A+)  380 Pts  #3 Heritage  SBR rating A+  Review  
#4 Pinnacle (SBR rating A+)  310 Pts  #4 BetOnline  SBR rating A+  Review  
#5 BetOnline (SBR rating A+)  165 Pts  #5 Intertops  SBR rating A  Review 
=1/(1+exp((0.61323+0.167546*(3.01))))
I assume you mean raising e to that power. Not subtracting it from e
The result is
0.527202 is that close to what you want?
3QUESTION
SBR TRIVIA WINNER 04/08/2019
Go to Formulas on the ribbon at the top.
Select Name manager
Select New
Type dSRS
Select the cell where you will have dSRS in the refers section
Close the name manager
you can use this formula
=EXP(drRs*0.167)
is there a reason you want to lock it to a specific cell? You know that you can just select the cell and get the same result, right? If you type A1, it will give you the negative of what is in cell A1
3QUESTION
SBR TRIVIA WINNER 04/08/2019
You need to specify order of operations.
Do you want
The natural log of 1/(N71) or the natural log of ((1/n7)1)
Option 1: =ln(1/(N71))/0.13959
Option 2: =ln((1/N7)1)/0.13959
3QUESTION
SBR TRIVIA WINNER 04/08/2019
3QUESTION
SBR TRIVIA WINNER 04/08/2019