excel 2003

L

ldmere

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
 
R

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
 
T

Tyro

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with Time Distribution Formula 2
Filling formulas with specific cell references remaining the same 2
Macro to copy data when data is detected in another column(s). 2
Lookup Function Help 1
Easier way to concatenate a row? 8
the formula sees the cell with a value 2
Conditional format refers to two cells 1
concatenate more column value 3

Top