I would like to have two separate functions in one cell

[dpston]

Hello, I have two different outcomes in my workbook that I would like to combine in to one formula. I'm sure there is a way out there. Basically, I would like to combine these two formulas in one cell:

=(1.65*0.000125^(B43-1))*((1-EXP(-0.04*D24))/4.15)

Or, if I were to enter "Dry hop" in D24, I would like for the outcome to be 0. Here is a crude example

=LOOKOUT D24 {"Dry hop"},{0}

Most of the time, I plug in numbers in D24. But, occasionally, I will type in "Dry hop". I do not want to see #Value! or have to change the formula. I would love to be able to combine these two formulas(or some variant). I know you wizards out there have a way. Thank you in advance.

[p24leclerc]

here is your formula:

Please Login or Register  to view this content.

[dpston]

Thank you very much. I was fairly close. But, I was done beating my head on the wall. You guys are awesome. Thanks again.