Thank you for your responses Tommy and Martin (and to all others who
were working on a solution for me).

I actually tried Tommy's suggestion first with good results. Of course,
I did have a problem but it was my fault (I couldn't get the Value If
False formula to work right). So, I just cleared the cell, started from
scratch, selected the IF logic function next to the function editor. I
then used B2="Male” for the Logical Test, and I copied the formulas
from my sheet where I worked them out, and viola! Success!

Thank you again for your help. I do appreciate it. And if you want a
copy of this spreadsheet, please let me know. I am modeling it after
the calculations section in the Bowflex training manual, but using
excel for the computations in case you want to see a "what if"
scenario. It's kinda' neat. Right now it has Body Mass Calculations, a
Results section (before and after measurements) and a nomogram (the
problem we just worked on); taking three measurements and using your
age you can compute your percent body fat. The nomogram is pretty big
though as it is a spreadsheet with 10 to 150 mm in the i direction and
15 to 50 years old for the j direction. I like the single cell formula
which depends on other cells input. It’s cleaner too.

Well, until next time…
Best Regards,
Thomas



--
thomasstyron
------------------------------------------------------------------------
thomasstyron's Profile: http://www.excelforum.com/member.php...o&userid=25568
View this thread: http://www.excelforum.com/showthread...hreadid=389991