When you have 210-E3; the formula expects a numeric in E3..It returns a
#value error because E3 is not a numeric..

If this post helps click Yes
---------------
Jacob Skaria


"Mark" wrote:

This is what I have now =IF(E3="H", 220-F3, MAX(MIN(210-E3,60),0) )

When E3 = H then the formula works fine, when it is not H then I get #Value!
in the cell.

"Lars-Åke Aspelin" wrote:

On Sat, 8 Aug 2009 07:14:01 -0700, Mark
wrote:

I have a formula in column G =MAX(MIN(220-F2)) that I want to set only if
the text in column E is set to the value of "H". If the value in column E is
< H then I want the formula in column G to be =MAX(MIN(210-E2,60),0).

How do I have this conditional formula in the same cell?

Try this:

=IF(G2="H", your first formula here , your second formula here )

Your first formula looks a bit odd. Have you mistyped it?
If it really is
=MAX(MIN(220-F2))
you can simplify it to just
=220-F2

Hope this helps / Lars-Åke