Forum Discussion
Specific Excel Formula Help
Hey guys, I'm new here so sorry if this isn't a very tough question but how would i input a formula that would read, Knowing that in 1 case of QTR there are 4 sleeves and each sleeve has 15 units.
| Product | Case | Sleeve | Unit | Total Units |
| QTR1(Pre Day) + | 1 | 3 | 70 | 175 |
| QTR2(Post Day) - | 0 | 2 | 30 | 60 |
| QTR3(Difference/End Day Total) = | 1 | 3 | 10 | 115 |
I would need this on a scale for about 30 separate Items formatted the Same way as QTR but Independent, So any help with the formula or a Better Idea on how to format it to get the same result would be much appreciated!
- Assuming "Product" is in A1 then this formula should yield the 175:
=(B2*4+C2)*15+D2
