Forum Discussion
Solved
Syntax help in a formula
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,"")))
- This is the complete formula:
=IF(ISNUMBER($R30),
ROUNDDOWN(($Y$17-$Y$18)/$Q30,0),
“”)
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?
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?
- Modify the logical_test argument of IF to this:
ISNUMBER($R30)Thank you, but when I try \
=ISNUMBER($R30, ROUNDDOWN(($Y$17-$Y$18)/$Q30,0),“”)
Im back to "too few arguments" error.
- This is the complete formula:
=IF(ISNUMBER($R30),
ROUNDDOWN(($Y$17-$Y$18)/$Q30,0),
“”)