Thank you to Gary’s Student and David for the help and to all others who
were working on a solution for me.

And David, sorry about the format; yeah, looking back it probably would
have been easier to read as if it was in a spreadsheet rather than in
paragraph form, but as this is my second question on this forum, I am
still learning. I’ll try to get it right in the future, just please
bear with me. :) I have been known to work hard rather than smart
sometimes.

And finally, the suggestions were great. Unfortunately now I have
another problem as a result of my oversimplification of my equation.
Here’s what I wanted to show a zero for a value of less than zero:

=IF(B2="Male",((4.95/(1.10938-(0.0008267*C8)+(0.0000016*((C8)^2))-(0.0002574*A2)))-4.5),((5.01/(1.0994921-(0.0009929*C8)+(0.0000023*((C8)^2))-(0.0001392*A2)))-4.57))

And I want to use Gary’s Student’s suggestion of using
=MAX(0,expression). How do I combine two functions into one?

Thanks again,
Thomas


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