I am trying to figure out how to get the following FN function to work.
=EXP(INTERCEPT(LN(B58:S58),LN(B69:S69)))
The problem from what I understand is that there are some blank and/or 0 values in the range that LN is looking for. I cant get around this by just altering the range because in some scenarios some data may be missing or 0, and in other scenarios other data may be missing or 0. The following equations also have the same problem.
=RSQ((LN(B58:S58)),(LN(B69:S69)))
=SLOPE(LN(B59:S59),LN(B70:S70))
The data in the range is found by this formula,
=IF(B46*(60/B$45)>0,B46*(60/B$45),""), just in case there is something wrong with that. Maybe something other that "" will help.
If I enter in values in every cell its looking up, it works like a charm, but I need it to just skip a value if its missing, blank, "", or 0.
Bookmarks