How to round to nearest integer

Hi,

You should set the “ROUND” operation, for each return of the equation, like follow:

(function(){
if(fieldname11==1 && fieldname12==1){
return ROUND((fieldname5-(fieldname5*(fieldname10/100)))*2.3);
}
if(fieldname11==1 && fieldname12==2){
return ROUND((fieldname5-(fieldname5*(fieldname10/100)))*2.6);
}
if(fieldname11==1 && fieldname12==3){
return ROUND((fieldname5-(fieldname5*(fieldname10/100)))*2.9);
}
if(fieldname11==2 && fieldname17==1){
return ROUND(fieldname5*2.2*.7);
}
if(fieldname11==2 && fieldname17==2){
return ROUND(fieldname5*2.2*.8);
}
if(fieldname11==2 && fieldname17==3){
return ROUND(fieldname5*2.2*.9);
}
})()

Best regards.

Thank you very much for your prompt response.

Hi,

I’m having the same problem but I think mine would be simpler, I want to ask if you could help me out with my equation…

I’m currently using MS Excel equation as it looks to be working for the plugin, my equation is:

IF(fieldname2>10001,FLOOR(fieldname2,10000))*0.01

so the result should be rounded down to the nearest ten thousand then multiplied it by 0.01

Hoping to hear from you soon.
Thanks.

Hi,

Your equation has some issues:

The “IF” operation requires three parameters: condition, value to return if the condition is true, and value to return if the condition is false. Furthermore, the FLOOR operation in our plugin accepts only one parameter, so, if you want rounded down to the nearest ten thousand, you should use a little trick, like in the following equation:

IF(fieldname2>10001, FLOOR(fieldname2/10000)*10000*0.01, fieldname2*0.01)

Best regards.

Hi,

Thanks for the quick reply, I forgot to tell you that the form works, But now I want to do something else, I was hoping you could help me out, you see on a calculated field when the value is zero I want to to show as empty or blank input result instead of displaying the number 0 here is my equation:
fieldname14*.51+fieldname14

I know i need to maybe use the if and else function? I just don’t know how to do it.

Best Regards.

Hi,

Yes, you are in the right direction. A solution would be:

(function(){
var r = fieldname14*.51+fieldname14;
return (r) ? r : '';
})()

A review of the plugin would be appreciated.

Best regards.