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-EXP(-B16(B25-B17))) but keep getting #REF! Any help is much appreciated:) Thank you

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!

#REF! when applying formula | Microsoft Community Hub

5 Replies

Haytham Amairah
Silver Contributor
Mar 17, 2018
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!
- Samantha Amy Webb
  Copper Contributor
  Mar 17, 2018
  Thank you very much, I'm actually getting a figure now!
  
  Q:The bolded & underlined is an exponent of -B16 though (i.e. like a ten to the power of 2, 10^2)
  
  =B15*(1-EXP(-B16*(B25-B17)))
  
  Will this effect the equation?
  - Haytham Amairah
    Silver Contributor
    Mar 17, 2018
    Hi Samantha,
    
    EXP function takes this constant (2.71828182845904) and raised it to the result of this: -B16*(B25-B17).
    
    If the result of this portion: -B16*(B25-B17) is 5, then it looks like this:
    
    2.71828182845904^5
    
    I'm not sure that this is what you want, but https://support.office.com/en-us/article/exp-function-c578f034-2c45-4c37-bc8c-329660a63abe?NS=EXCEL&Version=16&SysLcid=1033&UiLcid=1033&AppVer=ZXL160&HelpId=xlmain11.chm60069&ui=en-US&rs=en-US&ad=US is programmed this way.
Samantha Amy Webb
Copper Contributor
Mar 17, 2018
𝐿𝑎=𝐿∞(1−𝑒^−𝐾(𝑎−𝑡zero)) my apologies

Forum Discussion

#REF! when applying formula