the CEILING in excel

Yohan Hidalgo

November 16, 2015 18:32

Hi everyone,

I can't get this to work in a calculation field:

(@FieldA === 1?0:(@FieldB == "Text 1"?0:(@FieldB == "Text 2"?Math.round((0.9*(CEILING(2*@FieldC.1/3,5)))/25,0)25:CEILING(2@FieldC.1/3,5))))

Excel is:

=IF(B11=1,0,IF($B$18="Text 1",0, IF($B$18="Text 2",ROUNDUP((0.9*(CEILING(2*$B$24/3,5)))/25,0)25, CEILING(2$B$24/3,5))))

Error from Podio:

Preview: Script syntax error: Unexpected token ILLEGAL

any thoughts?

-- thanks!

0

Comments

1 comment

Rainer Grabowski

November 17, 2015 07:59
Use Javascript operators instead of Excel functions, Math.ceil() instead of CEILING. And please use markdown to show code when you use special characters like
- _
cause strings between those characters will be shown italic or bold and the * disappear. Enter 4 blank spaces in front of each line of your code and a blank line before and after the code block and the code looks much clearer like
```
(@FieldA === 1?0:(@FieldB == "Text 1"?0:(@FieldB == "Text 2"?Math.round((0.9*(CEILING(2*@FieldC.1/3,5)))/25,0)25:CEILING(2@FieldC.1/3,5))))
```
Another point: Your code looks very unclear. Use blank spaces before and after ? and :
0

Comment actions Permalink

Please sign in to leave a comment.

Powered by Zendesk