Formulas using two cells
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
|