AgTalk Home
AgTalk Home
Search Forums | Classifieds | Skins | Language
You are logged in as a guest. ( logon | register )

Excel formula IF statements help
View previous thread :: View next thread
   Forums List -> Computer TalkMessage format
 
Chris
Posted 10/8/2008 20:47 (#478063 - in reply to #477714)
Subject: Thank you, more will follow



East central Iowa

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.

 

 

Top of the page Bottom of the page


Jump to forum :
Search this forum
Printer friendly version
E-mail a link to this thread

(Delete cookies)