# Weighted Forecast - IF formula

I'm trying to put together a formula that will populate a weighted forecast only if the probability is 80%, 90% or 100%.

I was thinking a column formula using IF.

The formula does not get an #unparseable, but the result is just a blank cell. How would I get the formula to populate \$298,240?

• Overachievers

@Adrienne Strong if this makes sense, change your formula to

=if(probability@row >=0.8, [design or procurement fee]@row * probability@row, "")

that way if probability is greater or equal to 80% it will multiple your \$\$ by the probability in the same row, otherwise it will return nothing (<80\$)

• Overachievers

@Adrienne Strong if this makes sense, change your formula to

=if(probability@row >=0.8, [design or procurement fee]@row * probability@row, "")

that way if probability is greater or equal to 80% it will multiple your \$\$ by the probability in the same row, otherwise it will return nothing (<80\$)

• @Samuel Mueller Thank you! That solved it.

• Overachievers

Awesome!

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!