alohafromHI
New Member
- Joined
- Oct 15, 2016
- Messages
- 3
Hi everyone,
So for the sake of an example, say I want to calculate a prices per pound, but there are different colored containers that indicate different prices. Like a red container is $1/pound, a green container is $2/pound and a blue container is $3/pound. So my Data Table would look something like below (w/o equations):
<tbody>
</tbody>
So if someone is buying 1 pound of something, the price would be different depending on which color container it is in: $1 in red container, $2 in green, and $3 in blue. But since the formulas for each container are different, Data Tables gets messed up (so the table above isn't actually possible). Is there a way that I can somehow set a category for the container color that would dictate which equation Excel would use based on the category I select? Or would I just need to make a separate data table for the red containers, one for the blue, and one for the green?
Thanks
So for the sake of an example, say I want to calculate a prices per pound, but there are different colored containers that indicate different prices. Like a red container is $1/pound, a green container is $2/pound and a blue container is $3/pound. So my Data Table would look something like below (w/o equations):
Color | Weight (lbs.) | Price |
Red | 1 | =[@weight]*1 = $1 |
Green | 1 | =[@weight]*2 = $2 |
Blue | 1 | =[@weight]*3 = $3 |
<tbody>
</tbody>
So if someone is buying 1 pound of something, the price would be different depending on which color container it is in: $1 in red container, $2 in green, and $3 in blue. But since the formulas for each container are different, Data Tables gets messed up (so the table above isn't actually possible). Is there a way that I can somehow set a category for the container color that would dictate which equation Excel would use based on the category I select? Or would I just need to make a separate data table for the red containers, one for the blue, and one for the green?
Thanks