# Get instant live expert help on convert ounces to gallons

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

## Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

## Here are some problems that our users have asked and received explanations on

I made a drop down list in a worksheet to convert between ounces, kilograms, grams and pounds. When scroll down to kilogram I get A #NA error. Here is the formula I used. =CONVERT(H18,K17,N17) If I scroll between the other units they all convert fine. But if I use Kilograms I get the error.
Solved by O. C. in 24 mins
Up to 5000 sf = 15 gallons/sf Next 10000 sf = 10 gallons/sf Up to 17684 sf = 3 gallons/sf I need this to be all one formula referencing one cell
Solved by F. A. in 18 mins
Need formula to convert 4.68 Gal (or any amount of gallons, >.001) to read/display as in a single/adjacent cell 4.5 Gal, 1 Pt, 2/3 Cup, 3 Tbl, 1 1/4 Tsp
Solved by T. Q. in 14 mins
You work for a company that sells olive oil. Below is the how the company determines cost per gallon of olive oil based on number of gallons sold cost/gallon for the first 500 gallons: \$23 Cost/gallon for the above 500 gallons: \$20
Solved by I. U. in 19 mins
I need help with a yearly utility spreadsheet. I need to know how to input gallons used and excel automatically fill the sewer and water charges. I have a gallons used price spreadsheet.
Solved by F. L. in 12 mins