Forum Discussion
#REF! when applying formula
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!
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!
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?
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.
Hi Haytham,
So I have attached a different formula but still using exponents which formula is correct
=F25-1*EXP((-E26)-1) or
=EXP(F25-1)^(-E26)-1
where Na-1 = F25-1 and the -Za-1 = -E26-1
Thank you in advance!!
