Hi, I'm not great with formulas but need to create a formula for a weighted forecast. In one column I have a $ value. In another column for probability I have single select drop down with options such as "20% - Bidding", "30% - Shortlisted" etc. I need the weighted forecast column to apply an IF calculation that multiples the $ value by the % value of the probability column.
Example: If Probability = "20% - Bidding" multiply the $ by .20. Alternatively if Probability = "30% - Shortlisted" multiply the $ by .30.
Result would be: $1 x .20 = $0.20 of $1 x .30
How do i write this formula?
Help Article Resources
Check out the Formula Handbook template!