You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser.
excel 2003
-
Thread starter
ldmere
-
Start date
How do I replace a formula with a text statement ?
K2
=IF(Q2>P2,P2,(Q2<P2,Q2))
If L2 cell is "Y" or "P", I want K2 to either be blank or "Extd"
Thanks
Rick Rothstein \(MVP - VB\)
If I understand your question correctly, put this formula in K2...
=IF(L2="Y","",IF(L2="P","Extd",IF(Q2>P2,P2,(Q2<P2,Q2))))
Rick
The statement =IF(Q2>P2,P2,(Q2<P2,Q2)) has an error in it. I presume you
want =IF(Q2>P2,P2,IF(Q2<P2,Q2)). But then, what do you want if Q2 = P2?
Tyro
