ExcelBanter - Value_if

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Value_if_true (https://www.excelbanter.com/excel-worksheet-functions/48063-value_if_true.html)

Cheryl

Value_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," ?

David Billigmeier

=IF(B2<"","Dear "&B2&",","To Whom It May Concern:")

--
Regards,
Dave

"Cheryl" wrote:

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," ?

Cheryl

Worked like a charm-- Thank you! You are wonderful!

"David Billigmeier" wrote:

=IF(B2<"","Dear "&B2&",","To Whom It May Concern:")

--
Regards,
Dave

"Cheryl" wrote:

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," ?

All times are GMT +1. The time now is 06:58 AM.