 • 409K Members
• 11.5K Online
• 466K Conversations
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,"")))

12 Replies

Re: Syntax help in a formula

It should be like this:
=IF(\$R30>0.00001,
ROUNDDOWN((\$Y\$17-\$Y\$18)/\$Q30,0),
“”)

Re: Syntax help in a formula

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?

Re: Syntax help in a formula

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?

Re: Syntax help in a formula

Modify the logical_test argument of IF to this:
ISNUMBER(\$R30)

Re: Syntax help in a formula

Thank you, but when I try \

=ISNUMBER(\$R30, ROUNDDOWN((\$Y\$17-\$Y\$18)/\$Q30,0),“”)

Im back to "too few arguments" error.

Solution

Re: Syntax help in a formula

This is the complete formula:
=IF(ISNUMBER(\$R30),
ROUNDDOWN((\$Y\$17-\$Y\$18)/\$Q30,0),
“”)

Re: Syntax help in a formula

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.

Re: Syntax help in a formula

If you prefer to return 0, if the result of the logical_test argument is FALSE, then replace the value_if_false argument with 0, like this:
=IF(ISNUMBER(\$R30),
ROUNDDOWN((\$Y\$17-\$Y\$18)/\$Q30,0),
0)
Note that a #NAME? error is returned, if the formula includes a name that is not defined in the Name Manager.

Re: Syntax help in a formula

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.

Re: Syntax help in a formula

Thank you Twifoo, all is perfect now

Thank you

Re: Syntax help in a formula

Welcome!
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
21 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
12 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies