Weighted Forecast - IF formula

Adrienne Strong

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?

Samuel Mueller

@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

@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$)

Adrienne Strong

@Samuel Mueller Thank you! That solved it.

Samuel Mueller

Awesome!