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

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

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

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

I am looking for a formula that will take a 3 letter abbreviation in ex: the row C and from a table spreadsheet in the workbook auto fill row B with the manufacturers name?

Solved by M. L. in 13 mins

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