Formulae or Lookup Tables?

**FDibbins** · 07-22-2013, 06:22 PM

OK I think you are making this way too complex

I assume that your formulas are based on certain combinations of those 3 categories, so I would suggest you have a set of 3 tables, 1 for each category. Then in 1 formula (or maybe 3, each in a helper), yuu calc the value for each part, and then add them together

so for instance, for Male, you have a value, for Caucasian, you have a value etc. we can put something together that will grab the values based on those criteria, but you will need to put the tables together for me

**OverKnight** · 07-23-2013, 02:05 PM

Thank you, FDibbins. I do, at times, have a predilection to make things more complicated than necessary...

I'm not sure if I'm following you. What do you mean by "category"? Do you mean age, gender and race? As in the example, there are four age ranges (the adolescent range changes based on gender), three races and two genders. On the attached sheet, columns H and I list the gender-race-age categories and the associated equations. I've modified this sheet to include where the equation result will be (F2). The issue is selecting the correct equation based upon the data in A2:C2, and then displaying the result in F2 (data in B2 and D2 are used in the equations).

Thanks again.