
Litchfield MN.  I'm wanting to build a spreadsheet to calculate amounts of chemical to put in a sprayer load. I have the Chem rate and the acres to be sprayed.
Is there a way to have the spreadsheet out put gallons and oz's of a product instead of gallons and fraction of a gallon?
Example: 6oz/a x 47 acres = 2.2 gal. (I know how to do that formula in the spreadsheet)
Is there a way to have it show it as 2gal. 26oz.?
Thanks
 
