bbbuffalo
Board Regular
- Joined
- Apr 14, 2006
- Messages
- 53
I have several products and sales reps can select them in the pricing calcuator in Column A.
When a rep selects a product in Column A, the price per item automatically appears in Column B, they then enter the quantity in column C and then the total appears in Column D
However, if they select a certain product (Let's call it Enterprise Software), there is a minimum charge for that. If the quantity is less than 10, it still needs to be a minimum of 10, however if it's more than 10 then it should be whatever that amount is that the rep entered.
How do I create a minimum value if a certain product was selected?
When a rep selects a product in Column A, the price per item automatically appears in Column B, they then enter the quantity in column C and then the total appears in Column D
However, if they select a certain product (Let's call it Enterprise Software), there is a minimum charge for that. If the quantity is less than 10, it still needs to be a minimum of 10, however if it's more than 10 then it should be whatever that amount is that the rep entered.
How do I create a minimum value if a certain product was selected?