What is the VBA Excel formula for converting oil stock measurement from drums to liters?

liters
stock

asked 2023-05-29 20:16:33 +0000

lalupa
21 ●1 ●1

edit retag flag offensive close merge delete

add a comment

1 Answer

Sort by » oldest newest most voted

answered 2023-05-29 20:33:02 +0000

bukephalos
21 ●4 ●3

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.

edit flag offensive delete link

add a comment

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account. This space is reserved only for answers. If you would like to engage in a discussion, please instead post a comment under the question or an answer that you would like to discuss

Add Answer

Question Tools

Stats

Asked: 2023-05-29 20:16:33 +0000

Seen: 9 times

Last updated: May 29 '23

What is the VBA Excel formula for converting oil stock measurement from drums to liters? edit

1 Answer