Revision history [back]
 | 1 | initial version |
The conversion factor for oil in drums to liters is 1 drum = 159. litres. So, to convert oil stock measurement from drums to liters in VBA Excel, multiply the number of drums by 159. The formula would be:
Liters = Drums * 159
For example, if you have 50 drums of oil in stock, the VBA Excel formula to convert it to liters would be:
Liters = 50 * 159 Liters = 7950
Therefore, you have 7950 liters of oil in stock.