Your first formula doesn't make much sense as there is only a single argument meaning it is the same as 220-F2. Given that, try putting this in G2 (and copying down as needed)...

=IF(E2="H",220-F2,MAX(MIN(210-E2,60),0))

--
Rick (MVP - Excel)


"Mark" wrote in message ...
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?