Title: [Plugin: Jazzy Forms] quantity pricing
Last modified: August 20, 2016

---

# [Plugin: Jazzy Forms] quantity pricing

 *  [rottenuncle](https://wordpress.org/support/users/rottenuncle/)
 * (@rottenuncle)
 * [13 years, 11 months ago](https://wordpress.org/support/topic/plugin-jazzy-forms-quantity-pricing/)
 * Any plans to implement quantity pricing? Would love to be able to define (or 
   import) a quantity/price matrix so that when the user enters a quantity, the 
   correct price is used in the calculation.
 * Second-best alternative would be the ability to reference a dropdown option title
   as well as the option value in calculations. That way the option titles could
   be quantities and the values could be prices.
 * [http://wordpress.org/extend/plugins/jazzy-forms/](http://wordpress.org/extend/plugins/jazzy-forms/)

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

 *  Plugin Author [jazzigor](https://wordpress.org/support/users/jazzigor/)
 * (@jazzigor)
 * [13 years, 11 months ago](https://wordpress.org/support/topic/plugin-jazzy-forms-quantity-pricing/#post-2854021)
 * Hi. Yes, I’m thinking about a new element called Table or Matrix that would not
   be visible but instead would simply hold the quatity and price values. There 
   would then be a function similar to VLOOKUP/HLOOKUP. That would be the closest
   thing to a typical spreadsheet solution for gliding prices (at least for advanced
   spreadsheet users).
 * At the time of writing (v0.9.8) this is not implemented yet. There is, however,
   an alternative that works already, using nested IF functions. It gets tedious
   with large numbers of prices, but the idea for such a price formula would be 
   like the following example:
 * `IF(quantity>100, price1, IF(quantity>50, price2, IF(quantity>20, price3, price4)))*
   quantity`
 * I hope you get the idea. The syntax for the IF function is `IF(condition, value_if_true,
   value_if_false)`.
 *  Thread Starter [rottenuncle](https://wordpress.org/support/users/rottenuncle/)
 * (@rottenuncle)
 * [13 years, 11 months ago](https://wordpress.org/support/topic/plugin-jazzy-forms-quantity-pricing/#post-2854197)
 * Sounds like that would work well. Once you get that implemented along with conditional
   display of form elements, then Jazzy Forms will work well for me. Until then,
   I have too many prices & products for the nested IFs to work well. Any idea when
   those 2 features might be ready to go?
 *  Thread Starter [rottenuncle](https://wordpress.org/support/users/rottenuncle/)
 * (@rottenuncle)
 * [13 years, 9 months ago](https://wordpress.org/support/topic/plugin-jazzy-forms-quantity-pricing/#post-2854331)
 * Any idea when the Table or Matrix element and the conditional display of form
   elements features might be implemented?

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

The topic ‘[Plugin: Jazzy Forms] quantity pricing’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/jazzy-forms_dac291.svg)
 * [Jazzy Forms](https://wordpress.org/plugins/jazzy-forms/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/jazzy-forms/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/jazzy-forms/)
 * [Active Topics](https://wordpress.org/support/plugin/jazzy-forms/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/jazzy-forms/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/jazzy-forms/reviews/)

 * 3 replies
 * 2 participants
 * Last reply from: [rottenuncle](https://wordpress.org/support/users/rottenuncle/)
 * Last activity: [13 years, 9 months ago](https://wordpress.org/support/topic/plugin-jazzy-forms-quantity-pricing/#post-2854331)
 * Status: not resolved