I have made a very good worksheet for work but I can't seem to figure out a formula for this problem.
[TABLE="width: 259"]
<colgroup><col width="110" style="width: 83pt; mso-width-source: userset; mso-width-alt: 4022;"> <col width="107" style="width: 80pt; mso-width-source: userset; mso-width-alt: 3913;"> <col width="128" style="width: 96pt; mso-width-source: userset; mso-width-alt: 4681;"> <tbody>[TR]
[TD="class: xl69, width: 110, bgcolor: transparent"]Inventory[/TD]
[TD="class: xl69, width: 107, bgcolor: transparent"]Consumption[/TD]
[TD="class: xl69, width: 128, bgcolor: transparent"]Current Inventory[/TD]
[/TR]
[TR]
[TD="class: xl70, bgcolor: transparent"]250[/TD]
[TD="class: xl71, bgcolor: transparent, align: right"]3[/TD]
[TD="class: xl66, bgcolor: transparent"]*[/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent, align: right"]6[/TD]
[TD="class: xl68, bgcolor: transparent"]*[/TD]
[/TR]
</tbody>[/TABLE]
I am having a hard time getting both numbers to match up. My whole spreadsheet is filled with 1-6 different consumption factors. If anyone could show me a basic one to figure out just two I'm sure I can figure out the larger numbers.
Any help is greatly appreciated!
[TABLE="width: 259"]
<colgroup><col width="110" style="width: 83pt; mso-width-source: userset; mso-width-alt: 4022;"> <col width="107" style="width: 80pt; mso-width-source: userset; mso-width-alt: 3913;"> <col width="128" style="width: 96pt; mso-width-source: userset; mso-width-alt: 4681;"> <tbody>[TR]
[TD="class: xl69, width: 110, bgcolor: transparent"]Inventory[/TD]
[TD="class: xl69, width: 107, bgcolor: transparent"]Consumption[/TD]
[TD="class: xl69, width: 128, bgcolor: transparent"]Current Inventory[/TD]
[/TR]
[TR]
[TD="class: xl70, bgcolor: transparent"]250[/TD]
[TD="class: xl71, bgcolor: transparent, align: right"]3[/TD]
[TD="class: xl66, bgcolor: transparent"]*[/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent, align: right"]6[/TD]
[TD="class: xl68, bgcolor: transparent"]*[/TD]
[/TR]
</tbody>[/TABLE]
I am having a hard time getting both numbers to match up. My whole spreadsheet is filled with 1-6 different consumption factors. If anyone could show me a basic one to figure out just two I'm sure I can figure out the larger numbers.
Any help is greatly appreciated!