MrHydrant1857
New Member
- Joined
- Mar 29, 2019
- Messages
- 35
Hi all,
I have an excel sheet that has a dropdown with different selections (Products) in it and based on that selection a certain cell generates a preset number from a table. I have then another cell before that where I can enter a number manually. finally I have a cell with a formula in it that takes the preset number multiplied by the number that is manually entered and outputs the answer. the trick is that if the manually entered number is 3 or below then it doesn't execute the equation, which I want to happen. so my question/problem is, I have certain products that require a different formula than the one being used. How do I get my formula cell to generate the correct formula based off my product selection? I have written examples below as it is hard for me to explain.
Product A selected:
(manually entered number) 3 / (Preset number) 32.50 / (Formula: =MAX(((B22-3)*2)*E22,0) ) *Cell is Blank
Product B selected:
(manually entered number) 3 / (Preset number) 32.50 / (Formula: =MAX(((B22-1)*2)*E22,0) ) *Cell returns: 130.00
I have an excel sheet that has a dropdown with different selections (Products) in it and based on that selection a certain cell generates a preset number from a table. I have then another cell before that where I can enter a number manually. finally I have a cell with a formula in it that takes the preset number multiplied by the number that is manually entered and outputs the answer. the trick is that if the manually entered number is 3 or below then it doesn't execute the equation, which I want to happen. so my question/problem is, I have certain products that require a different formula than the one being used. How do I get my formula cell to generate the correct formula based off my product selection? I have written examples below as it is hard for me to explain.
Product A selected:
(manually entered number) 3 / (Preset number) 32.50 / (Formula: =MAX(((B22-3)*2)*E22,0) ) *Cell is Blank
Product B selected:
(manually entered number) 3 / (Preset number) 32.50 / (Formula: =MAX(((B22-1)*2)*E22,0) ) *Cell returns: 130.00