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/11/2008 08:30 (#479807 - in reply to #478063)
Subject: RE: Thank you, more will follow



East central Iowa

The formula for the vlookup

=VLOOKUP(G4,$A$201:$B$323,2,FALSE)*((G4-15)*F4)

then in A201   I put  15 and in B201 I put 0  

I filled the column A with a series +.1 and put .04 in column B until I reached 20.1 in column A, then column B changed to .045 and so on.

Column G has the moisture and column F has the wet bushels.

 

So the formula finds the moisture listed in the table matching the load moisture (G), extracts the charge (in B) and multiples it times the wet bushels in F 

If they go by tenths this year this will work if they go by whole points the other formula will work.

 

 

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)