=IF(E3="H", 220-F3, MAX(MIN(210-F3,60),0) )


Hi. Instead of MAX(MIN(210-F3,60),0)

I like to use:

=MEDIAN(0,210-F3,60)

= = = = = = =
HTH
Dana DeLouis


Mark wrote:
That was it... it should have been 210-F3 and not E3... Thank you both for
the assistance.

"Jacob Skaria" wrote:

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