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

Equation in excel
View previous thread :: View next thread
   Forums List -> Computer TalkMessage format
 
gwagner
Posted 1/13/2022 10:11 (#9437421 - in reply to #9436343)
Subject: RE: Equation in excel



One of several examples;

First you need to build a table; (example 1) (not saying these are the correct shrink number just an example)

Then build your input lines (example 2)

In box c4 write the formula =LOOKUP(B3,E3:F42) This takes the value entered in B3(moisture) and looks up the value wanted

Then in b4 write the formula =B2*C4 This will take the lookup value (c4) and calculate the net bushels

Or you could get real fancy and use the formula in b4 =B2*(LOOKUP(B3,E3:F42)) and eliminate the extra box

(example 3) is the entire spread sheet

Once you understand the concept you can have the table on another page or hide the columns or even in another spreadsheet so the values do not get altered



Edited by gwagner 1/13/2022 10:40




(example 1 (full).jpg)



(example 2 (full).jpg)



(example 3 (full).jpg)



Attachments
----------------
Attachments example 1 (full).jpg (52KB - 13 downloads)
Attachments example 2 (full).jpg (8KB - 19 downloads)
Attachments example 3 (full).jpg (93KB - 7 downloads)
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)