Title: aderatis's Replies | WordPress.org

---

# aderatis

  [  ](https://wordpress.org/support/users/aderatis/)

 *   [Profile](https://wordpress.org/support/users/aderatis/)
 *   [Topics Started](https://wordpress.org/support/users/aderatis/topics/)
 *   [Replies Created](https://wordpress.org/support/users/aderatis/replies/)
 *   [Reviews Written](https://wordpress.org/support/users/aderatis/reviews/)
 *   [Topics Replied To](https://wordpress.org/support/users/aderatis/replied-to/)
 *   [Engagements](https://wordpress.org/support/users/aderatis/engagements/)
 *   [Favorites](https://wordpress.org/support/users/aderatis/favorites/)

 Search replies:

## Forum Replies Created

Viewing 3 replies - 1 through 3 (of 3 total)

 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[Calculated Fields Form - AI Form Builder for WordPress - Contact, Payment, Quote, Quiz & More] RE: Rounding Up to the next whole number](https://wordpress.org/support/topic/re-rounding-up-to-the-next-whole-number/)
 *  Thread Starter [aderatis](https://wordpress.org/support/users/aderatis/)
 * (@aderatis)
 * [9 years, 5 months ago](https://wordpress.org/support/topic/re-rounding-up-to-the-next-whole-number/#post-8872595)
 * Hi again,
    I must be getting this wrong somewhere because its still not giving
   the correct results for me. Here is the form source code I have pulled from a
   site which calculates the same as we do, although they also have and adhesive
   calculator underneath, but we don’t need that, only the wallpaper calculation:
 * <form name=”cp_calculatedfieldsf_pform_1″ id=”cp_calculatedfieldsf_pform_1″ action
   =”?” method=”post” enctype=”multipart/form-data”>
 *     ```
       <!--noptimize--><script>form_structure_1=[[{"form_identifier":"","name":"fieldname2","shortlabel":"","index":0,"ftype":"fnumber","userhelp":"","userhelpTooltip":false,"csslayout":"","title":"Width of wall (CM)","predefined":"eg. 360","predefinedClick":true,"required":true,"size":"small","thousandSeparator":"","decimalSymbol":".","min":"","max":"","dformat":"number","formats":["digits","number"],"fBuild":{}},{"form_identifier":"","name":"fieldname3","shortlabel":"","index":1,"ftype":"fnumber","userhelp":"","userhelpTooltip":false,"csslayout":"","title":"Height of wall (CM)","predefined":"eg. 240","predefinedClick":true,"required":true,"size":"small","thousandSeparator":"","decimalSymbol":".","min":"","max":"","dformat":"number","formats":["digits","number"],"fBuild":{}},{"form_identifier":"","name":"fieldname4","shortlabel":"","index":2,"ftype":"fCalculated","userhelp":"","userhelpTooltip":false,"csslayout":"","title":"Calc 1 width of wall\/130","predefined":"","required":false,"size":"medium","toolbar":"default|mathematical","eq":"fieldname2\/130","optimizeEq":true,"eq_factored":"(fieldname2\/130)","suffix":"","prefix":"","decimalsymbol":".","groupingsymbol":"","dependencies":[{"rule":"","complex":false,"fields":[""]}],"readonly":true,"hidefield":true,"fBuild":{}},{"form_identifier":"","name":"fieldname7","shortlabel":"","index":3,"ftype":"fCalculated","userhelp":"","userhelpTooltip":false,"csslayout":"","title":"calc 2 Round up calc 1","predefined":"","required":false,"size":"medium","toolbar":"default|mathematical","eq":"CEIL(fieldname4)","optimizeEq":true,"eq_factored":"(CEIL((fieldname2\/130)))","suffix":"","prefix":"","decimalsymbol":".","groupingsymbol":"","dependencies":[{"rule":"","complex":false,"fields":[""]}],"readonly":true,"hidefield":true,"fBuild":{}},{"form_identifier":"","name":"fieldname5","shortlabel":"","index":4,"ftype":"fCalculated","userhelp":"","userhelpTooltip":false,"csslayout":"","title":"Calc 3 Height of Wall\/100","predefined":"","required":false,"size":"medium","toolbar":"default|mathematical","eq":"fieldname3\/100","optimizeEq":true,"eq_factored":"(fieldname3\/100)","suffix":"","prefix":"","decimalsymbol":".","groupingsymbol":"","dependencies":[{"rule":"","complex":false,"fields":[""]}],"readonly":true,"hidefield":true,"fBuild":{}},{"form_identifier":"","name":"fieldname6","shortlabel":"","index":5,"ftype":"fCalculated","userhelp":"","userhelpTooltip":false,"csslayout":"","title":"Calc 4 height*no. of drops","predefined":"","required":false,"size":"medium","toolbar":"default|mathematical","eq":"fieldname5*fieldname7","optimizeEq":true,"eq_factored":"((fieldname3\/100)*(CEIL((fieldname2\/130))))","suffix":"","prefix":"","decimalsymbol":".","groupingsymbol":"","dependencies":[{"rule":"","complex":false,"fields":[""]}],"readonly":true,"hidefield":true,"fBuild":{}},{"form_identifier":"","name":"fieldname8","shortlabel":"","index":6,"ftype":"fCalculated","userhelp":"","userhelpTooltip":false,"csslayout":"","title":"Calc 5 10% waste","predefined":"","required":false,"size":"medium","toolbar":"default|mathematical","eq":"fieldname7*0.1","optimizeEq":true,"eq_factored":"((CEIL((fieldname2\/130)))*0.1)","suffix":"","prefix":"","decimalsymbol":".","groupingsymbol":"","dependencies":[{"rule":"","complex":false,"fields":[""]}],"readonly":true,"hidefield":true,"fBuild":{}},{"form_identifier":"","name":"fieldname9","shortlabel":"","index":7,"ftype":"fCalculated","userhelp":"","userhelpTooltip":false,"csslayout":"","title":"Calc 6 Required","predefined":"","required":false,"size":"medium","toolbar":"default|mathematical","eq":"fieldname6+fieldname8","optimizeEq":true,"eq_factored":"(((fieldname3\/100)*(CEIL((fieldname2\/130))))+((CEIL((fieldname2\/130)))*0.1))","suffix":"","prefix":"","decimalsymbol":".","groupingsymbol":"","dependencies":[{"rule":"","complex":false,"fields":[""]}],"readonly":true,"hidefield":true,"fBuild":{}},{"form_identifier":"","name":"fieldname10","shortlabel":"","index":8,"ftype":"fSectionBreak","userhelp":"","userhelpTooltip":false,"csslayout":"","title":"","fBuild":{}},{"form_identifier":"","name":"fieldname1","shortlabel":"","index":9,"ftype":"fCalculated","userhelp":"","userhelpTooltip":false,"csslayout":"","title":"Metres required:","predefined":"0","required":false,"size":"small","toolbar":"default|mathematical","eq":"CEIL(fieldname9)","optimizeEq":true,"eq_factored":"(CEIL((((fieldname3\/100)*(CEIL((fieldname2\/130))))+((CEIL((fieldname2\/130)))*0.1))))","suffix":" Metre\/s","prefix":"","decimalsymbol":".","groupingsymbol":"","dependencies":[{"rule":"","complex":false,"fields":[""]}],"readonly":true,"hidefield":false,"fBuild":{}},{"form_identifier":"","name":"fieldname12","shortlabel":"","index":10,"ftype":"fCalculated","userhelp":"","userhelpTooltip":false,"csslayout":"","title":"Calc 7 Adhesive Required","predefined":"","required":false,"size":"medium","toolbar":"default|mathematical","eq":"fieldname1\/16","optimizeEq":true,"eq_factored":"((CEIL((((fieldname3\/100)*(CEIL((fieldname2\/130))))+((CEIL((fieldname2\/130)))*0.1))))\/16)","suffix":"","prefix":"","decimalsymbol":".","groupingsymbol":"","dependencies":[{"rule":"","complex":false,"fields":[""]}],"readonly":true,"hidefield":true,"fBuild":{}},{"form_identifier":"","name":"fieldname11","shortlabel":"","index":11,"ftype":"fCalculated","userhelp":"","userhelpTooltip":false,"csslayout":"","title":"Adhesive Required:","predefined":"0","required":false,"size":"small","toolbar":"default|mathematical","eq":"CEIL(fieldname12)","optimizeEq":true,"eq_factored":"(CEIL(((CEIL((((fieldname3\/100)*(CEIL((fieldname2\/130))))+((CEIL((fieldname2\/130)))*0.1))))\/16)))","suffix":" Tub\/s","prefix":"","decimalsymbol":".","groupingsymbol":"","dependencies":[{"rule":"","complex":false,"fields":[""]}],"readonly":true,"hidefield":false,"fBuild":{},"predefinedClick":false}],{"0":{"title":"","description":"","formlayout":"right_aligned","formtemplate":"cp_cff_elegant"},"formid":"cp_calculatedfieldsf_pform_1"}];</script><!--/noptimize-->
       ```
   
 * <div id=”fbuilder”>
    <div id=”fbuilder_1″> <div id=”formheader_1″></div> <div
   id=”fieldlist_1″></div> </div> </div> <div class=”clearer”></div> </form>
 * Is it possible to pull the information needed there, and if so could you tell
   me exactly which equations I need to put in which boxes please, I’m sorry to 
   be a pain, just want to get this working.
    Am I correct in understanding the 
   only thing that needs to be set in the width of wall and height of wall fields
   are the field labels? and the actual calculation (whatever that might amount 
   to) needs to go onto the ‘metres required’ field?
 * Kind Regards
 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[Calculated Fields Form - AI Form Builder for WordPress - Contact, Payment, Quote, Quiz & More] RE: Rounding Up to the next whole number](https://wordpress.org/support/topic/re-rounding-up-to-the-next-whole-number/)
 *  Thread Starter [aderatis](https://wordpress.org/support/users/aderatis/)
 * (@aderatis)
 * [9 years, 5 months ago](https://wordpress.org/support/topic/re-rounding-up-to-the-next-whole-number/#post-8872402)
 * Just to clarify my previous message, the actual width per sheet is 130 and height
   100.
    so when someone types in 100 as the width they still need to have the minimum
   width which is 130 x the required height in multiples of 100.
 * thanks.
 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[Calculated Fields Form - AI Form Builder for WordPress - Contact, Payment, Quote, Quiz & More] RE: Rounding Up to the next whole number](https://wordpress.org/support/topic/re-rounding-up-to-the-next-whole-number/)
 *  Thread Starter [aderatis](https://wordpress.org/support/users/aderatis/)
 * (@aderatis)
 * [9 years, 5 months ago](https://wordpress.org/support/topic/re-rounding-up-to-the-next-whole-number/#post-8872399)
 * Thanks for the quick reply, I am trying to calculate wallpaper to round up when
   displaying the result, the width is 130 and the height is 100, the current formula
   is CEIL(fieldname8/130*fieldname9/100) but when I type in 100 for the width (
   fieldname8) and 240 for the height (fieldname9) its displaying 2 metres, when
   it should be showing 3 metres.
 * Thanks in advance.

Viewing 3 replies - 1 through 3 (of 3 total)