Forum Discussion
Solved
#REF! when applying formula
Hi there,
I am having trouble applying this formula:
πΏπ=πΏβ(1βπ^βπΎ(πβπ‘zero))
where La= length at age of fish, Linfinity =696, k=0.292, a= age +0.5 and Tzero =-0.365
I have:
=B15(1-E...
Hi Samantha,
I have no idea about the equation you mentioned!
But I guess that this workaround will work:
=B15*(1-EXP(-B16*(B25-B17)))
You have to explicitly type multiplication sign so that Excel doesn't think it is something else!
Try for example to put this formula =5(5) in any cell!
Hit Enter and see what happens!
πΏπ=πΏβ(1βπ^βπΎ(πβπ‘zero)) my apologies