|
| 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 ---------------- example 1 (full).jpg (52KB - 233 downloads) example 2 (full).jpg (8KB - 218 downloads) example 3 (full).jpg (93KB - 222 downloads)
| |
|