Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

My formula doesnt work properly

So I have this table   Variety Size Min Max Max MM Min MM ProbA Grapefruit 18 4.83 6.06 153.924 122.682 0.993578 Grapefruit 23 4.38 4.82 122.428 111.252 0.844918 Grape...
Need Help
v-lionel-msft's avatar
v-lionel-msft
Community Support
5 years ago

Hi Anonymous ,

 

Or this.

Measure = 
NORM.DIST(
    //MAX represents the value of the current row here
    MAX([Min MM]),
    [Middle of this Range],
    [Average Standard Dev],
    TRUE()
)

 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.