03-08-2019 04:04 PM
03-08-2019 04:47 PM
Thank you very much. This took away the error. However the new formula continues to place a value in the cell when the r30 cell is empty. Why does it think an empty cell is greater than 0.00001?
03-08-2019 04:50 PM
Or better yet, is it possible to say "process this function only if r has any value" as opposed to saying "process if r is greater than 0.00001?
03-08-2019 05:35 PM
Thank you, but when I try \
Im back to "too few arguments" error.
03-08-2019 06:02 PMSolution
03-08-2019 11:37 PM
Thank you, this works. One final question. This leaves a "#NAME?" the cell. Not critical but I prefer either "0" or blank. I tried
03-09-2019 01:10 AM
03-09-2019 01:53 AM
Most probably it returns #NAME? since you copy the formula from that page as it is, on Web page apostrophes at the end of the formula are rounded apostrophes, CHAR(147). You need to change them on standard ones, CHAR(34). Or copy paste from code pane here:
=IF(ISNUMBER($R30), ROUNDDOWN(($Y$17-$Y$18)/$Q30,0), "")
it doesn't transform apostrophes.