View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Lars-Åke Aspelin[_2_] Lars-Åke Aspelin[_2_] is offline
external usenet poster
 
Posts: 913
Default 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