Hi Thomas,
You plop your current formula where you have expression, I've used
extra spaces to make it easier to see. Thank goodness I don't have
to work with the formula. The only thing you have to worry about is
a limit of 7 nesting levels. You only had one now you have two.

=MAX(0,
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)) )
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"thomasstyron" wrote in message
news:thomasstyron.1t0bya_1122768301.0293@excelforu m-nospam.com...

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