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
PaulDBrown's avatar
PaulDBrown
Icon for Community Champion rankCommunity Champion
5 years ago

Anonymous 

I can't test this, but according to the documentation, the first expression of the NORM.DIST function must be a number value (you are feeding it a column). 
so try an aggregation function like AVERAGE(Variety sizes[Min MM]) as the first expression:

NORM.DIST(AVERAGE(Variety sizes[Min MM]), ...etc