 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / September 2005Value_if_true
I am using an "if" formula. This is what I wrote =if(B2<>"","Dear B2,","To Whom It May Concern:") The value in B2 is "Nancy" This formula gives me the answer of "Dear B2," How do I get it to say "Dear Nancy," ? =IF(B2<>"","Dear "&B2&",","To Whom It May Concern:")  SignatureRegards, Dave > I am using an "if" formula. > This is what I wrote =if(B2<>"","Dear B2,","To Whom It May Concern:") > The value in B2 is "Nancy" > This formula gives me the answer of "Dear B2," > How do I get it to say "Dear Nancy," ? Worked like a charm-- Thank you! You are wonderful! > =IF(B2<>"","Dear "&B2&",","To Whom It May Concern:") > [quoted text clipped - 3 lines] > > This formula gives me the answer of "Dear B2," > > How do I get it to say "Dear Nancy," ? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.