Here are some problems that our users have asked and received explanations on
I need help with an IF formula, so i have to compute the number of gallons of gasoline consumed during each leg of the trip. depending on the trip, the gas is in either liters or gallons. I need to use =L_PER_GAL range name from the input output tab in my IF formula
Solved by T. F. in 15 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
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