Mar 08 2019 04:04 PM
Hello Community
Can anyone help me with my syntax below? This gets "too few arguments" error
=IF((($R30 > 0.00001), ROUNDDOWN(($Y$17-$Y$18)/$Q30,0,"")))
Mar 08 2019 04:31 PM
Mar 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?
Mar 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?
Mar 08 2019 05:24 PM
Mar 08 2019 05:35 PM
Thank you, but when I try \
=ISNUMBER($R30, ROUNDDOWN(($Y$17-$Y$18)/$Q30,0),“”)
Im back to "too few arguments" error.
Mar 08 2019 06:02 PM
SolutionMar 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
"=IF(ISNUMBER($R30),
ROUNDDOWN(($Y$17-$Y$18)/$Q30,0),
“0”)
without success.
Mar 09 2019 01:10 AM
Mar 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.
Mar 08 2019 06:02 PM
Solution