Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel 2003
How do I replace a formula with a text statement ?
K2 =IF(Q2P2,P2,(Q2<P2,Q2)) If L2 cell is "Y" or "P", I want K2 to either be blank or "Extd" Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel 2003
If I understand your question correctly, put this formula in K2...
=IF(L2="Y","",IF(L2="P","Extd",IF(Q2P2,P2,(Q2<P2, Q2)))) Rick "ldmere" wrote in message ... How do I replace a formula with a text statement ? K2 =IF(Q2P2,P2,(Q2<P2,Q2)) If L2 cell is "Y" or "P", I want K2 to either be blank or "Extd" Thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel 2003
The statement =IF(Q2P2,P2,(Q2<P2,Q2)) has an error in it. I presume you
want =IF(Q2P2,P2,IF(Q2<P2,Q2)). But then, what do you want if Q2 = P2? Tyro "ldmere" wrote in message ... How do I replace a formula with a text statement ? K2 =IF(Q2P2,P2,(Q2<P2,Q2)) If L2 cell is "Y" or "P", I want K2 to either be blank or "Extd" Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy and paste problem Excel 2003 to Word 2003 | Excel Discussion (Misc queries) | |||
opening excel files from access 2003, win xp, office 2003 | Excel Discussion (Misc queries) | |||
import Excel 2003 file into Outlook 2003 - NO NAMED RANGES?? | Excel Discussion (Misc queries) | |||
Copying Excel 2003 Selection into Outlook 2003 HTML E-Mail Message | Excel Discussion (Misc queries) | |||
Excel 2003 Database Driver Visual FoxPro 7 on Server 2003. | Excel Discussion (Misc queries) |