When write data to a .xlsm file,
existing formula like “LINEARINTERPOLATION” not work
like “=LINEARINTERPOLATION($R17,$B$28:$B$35,F$28:F$35)” will return as “#NAME?”
There should be no error in this formula, as I copy the formula to the cell beside it,get result:
image.png (691 Bytes)
Any possible way to solve it?
Thanks very much.
Also,when use formula like “=Sheet1!K8*(B85<>B84)”
If Sheet1!K8 is empty then will take as “” empty.
But in our template it returns 0 which cause the result as “#VALUE” not 0 as wished