Forum Discussion

Saraaaaa01's avatar
Saraaaaa01
Copper Contributor
Dec 30, 2022

when applying formula

Hi there,

I'm having trouble applying this formula:

πΏπ‘Ž=𝐿∞(1βˆ’π‘’^βˆ’πΎ(π‘Žβˆ’π‘‘zero))

where La= length at age of https://topfishingreel.com/, infinity =696, k=0.292, a= age +0.5 and Tzero =-0.365

I have:

=B15(1-EXP(-B16(B25-B17)))

but keep getting 

Any help is much appreciated:) Thank you

1 Reply

  • Saraaaaa01 

    In Excel, unlike in maths, you must indicate multiplication explicitly by using the * operator.

     

    =B15*(1-EXP(-B16*(B25-B17)))

Resources