Greg, Thank you, it works in both Open Office and in Excel. I don't like it when people don't get back to me after I've helped them so please accept my sincere thanks. I spent a couple of hours trying to adjust my old formula. I have a macro that runs my spreadsheet and moves from cell to cell. I have formulas that adjust the moisture so that I show dry bushels and dry sale vs wet sale. As our elevator stores for 3 months I also figure cash sale vs sale in 3 months. I did figure out a way to do the same thing using VLookup and it works for each .1 points. One year they went by 1/2 point difference and other years they go by tenths. The VLookup solves the .1 point problem. Our elevator does use .014 for shrinkage. So I show wet bushels, 15% bushels and 14% bushels because our elevator shrinks to 14% for storage. Something to take into consideration. Thanks again.
|