Posted 4/6/2022 11:54 (#9599863 - in reply to #9599564) Subject: RE: Excel formula question.
Eastern SD
Probably a few ways to do what you're after. I used the FLOOR function to get the number of whole gallons and then manipulated from there. First row shows the results, second row shows the formula's I used. Note you may want to round to a certain number of decimal places so you don't get 0.214235 ounces.