(800) 853-2651
SHOP NOW

kinda OT Excel problem

B

Bkpigs

Member
This is kinda off topic but does pertain to AG. I am needing to make a spread sheet that will corralate (sp?) a measurement to a weight (hog feeders). In reality the measurements are arbitrary since the container is not a consitant size through out. Therefore, an algebraic equation will not work. I will have 46 different measurements which would mean that if I used the nested IF/THEN funtion I would have a LONG and complex set of them.

Any ideas?


Thanks in advance
 
Go to the help screens and search on how to use a lookup table. That lets you put the measurements into a table and your function can go out and get a value from the table for the calculation.
 
First off, you will not be able to nest more than 7 if/then statements in Excel 2003 (I don't know if '07 or '10 can handle more).

Depending on the type of data you can set a table up and use the lookup functions.

Alternatively you could create a button and program a macro to run behind the scenes.

If I knew a bit more on the measurements your taking and how they correlate into weight I could be more specific.
 
Dave,

I will try, I don't want to put you out of your time though. This is for my employer so if I can't figure anything out, that is what they pay the bigwigs for. If you get my drift. Basically I want to type a number in the box (0 - 23 with halves) and in a cell next to it display the corresponding weight of feed. I was thinking of doing a line of nested IF/THEN functions starting with =If (A3<14,D3,E3) then in D3 I would have =If (A3<10.5,D4,E4) then in E4 I would have the IF/THEN for 10.5 through 13.5. and keep going like this.

I guess that way wouldn't take too long, just thought there may be another way.
 
Agree with all that using the LookUp function with a lookup table should/will work best for your project.

Years ago created an application for Mobil Oil here in Dallas.

Involved global drilling regions, drilling companies within drilling regions, and five (5) bids from each drilling company.

Create a "unique" key for each possibility your tracking.

Good luck on your project!
 
Dave,
Don't know if you can help me but it's XXX - 0, XXX - 0, XXX - oops.

Kinda need a spread sheet as well!

Just kiddin,
Jim
 
Yah, i realize you can only do 7 nested functions. That is why I was going to put them in kind of a series with one leading to another and so on.
 
It's not clear what you're trying to do.

Give us an actual example in human-readable language, not in Excel-speak. Half the work of problem-solving is articulating the problem itself.
 
I've done look up tables, but you really need to write out all the varibles to even get started.
 
It sounds like the vlookup may work for you.
place this formula in b1 and enter your value in a1.
=vlookup(a1,c1:d46,2) start in c1 and d1 and build a double column (ascending order) data set:
C D
1 100
1.5 150
2 200
2.5 250

in this example if you put 1 in a1 then 100 will show in b1 if you put 2.5 in a1 then 250 will show in b1.
 
Mark,

I understand what you mean, when I read it now, it is kinda confusing. I am going to use the lookup function that some of the guys suggested. Thanks anyhow.
 
You must log in or register to reply here.
Tractor Parts Tractor Manuals

We sell tractor parts! We have the parts you need to repair your tractor - the right parts. Our low prices and years of research make us your best choice when you need parts. Shop Online Today.

Copyright © 1997-2024 Yesterday's Tractor Co.

All Rights Reserved. Reproduction of any part of this website, including design and content, without written permission is strictly prohibited. Trade Marks and Trade Names contained and used in this Website are those of others, and are used in this Website in a descriptive sense to refer to the products of others. Use of this Web site constitutes acceptance of our User Agreement and Privacy Policy TRADEMARK DISCLAIMER: Tradenames and Trademarks referred to within Yesterday's Tractor Co. products and within the Yesterday's Tractor Co. websites are the property of their respective trademark holders. None of these trademark holders are affiliated with Yesterday's Tractor Co., our products, or our website nor are we sponsored by them. John Deere and its logos are the registered trademarks of the John Deere Corporation. Agco, Agco Allis, White, Massey Ferguson and their logos are the registered trademarks of AGCO Corporation. Case, Case-IH, Farmall, International Harvester, New Holland and their logos are registered trademarks of CNH Global N.V.

Yesterday's Tractors - Antique Tractor Headquarters
Website Accessibility Policy

Back
Top