Title: Tiered Prices
Last modified: October 29, 2018

---

# Tiered Prices

 *  Resolved [ben10ben10](https://wordpress.org/support/users/ben10ben10/)
 * (@ben10ben10)
 * [7 years, 6 months ago](https://wordpress.org/support/topic/tiered-prices/)
 * Hi, I am trying to make a calculated fields form using a formula I created in
   excel, but it is not working. Does anyone know how I can get this to work? Here
   is the formula in excel:
 * =IF(C21>12000,66.38+((C21-12000)/1000)*8.76),IF(C21>6000,34.46+((C21-6000)/1000)*
   5.32),IF(C21>5000,34.46,IF(C21>4000,29.57,IF(C21>3000,24.67,IF(C21>2000,13.04,
   IF(C21>1000,12.62,IF(C21>0,5.54,IF(C21=0,5.39)))))))))
 * I tried changing all of the C21 cells to the appropriate field name, but it is
   not working.
 * Thanks!

Viewing 1 replies (of 1 total)

 *  Plugin Author [codepeople](https://wordpress.org/support/users/codepeople/)
 * (@codepeople)
 * [7 years, 6 months ago](https://wordpress.org/support/topic/tiered-prices/#post-10825493)
 * Hello [@ben10ben10](https://wordpress.org/support/users/ben10ben10/),
 * The operation “IF” has some differences between our plugin’s implementation and
   the implementation in Excel,
 * – First, in our plugin you should remove the assignment symbol “=” at beginning
   of the formula. The equation would be directly: IF(
 * – Second, in javascript the equality operator is represented by the double sign“
   ==” and not “=” because this last represents the assignment, so, the piece of
   code: `fieldname21=0`, must be edited as: `fieldname21==0`
 * – Third, in our plugin the “IF” operation requires the structure: `IF(condition,
   result if condition true, result if condition false)`, so, this nested IF operation:
 * `IF(fieldname21=0,5.39)`
 * should be edited as:
 * `IF(fieldname21==0, 5.39, '')`
 * If you need additional help, please, indicate the URL to the web page where the
   form is inserted, for checking the formula in action.
 * Best regards.

Viewing 1 replies (of 1 total)

The topic ‘Tiered Prices’ is closed to new replies.

 * ![](https://ps.w.org/calculated-fields-form/assets/icon-256x256.jpg?rev=1734377)
 * [Calculated Fields Form](https://wordpress.org/plugins/calculated-fields-form/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/calculated-fields-form/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/calculated-fields-form/)
 * [Active Topics](https://wordpress.org/support/plugin/calculated-fields-form/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/calculated-fields-form/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/calculated-fields-form/reviews/)

 * 1 reply
 * 2 participants
 * Last reply from: [codepeople](https://wordpress.org/support/users/codepeople/)
 * Last activity: [7 years, 6 months ago](https://wordpress.org/support/topic/tiered-prices/#post-10825493)
 * Status: resolved