if conditional format, then a phone number

**chubbychub** · 06-11-2020, 08:23 PM

HI, I have the following formula in a cell base on a name. so if i pull a designers name , it will show his phone number

Please Login or Register  to view this content.

but when its empty, its shows "FALSE", maybe i am using a wrong method. please help, thank you.

**6StringJazzer** · 06-11-2020, 08:40 PM

The form of the IF function is

IF(condition, what to return it the condition is TRUE, what to return if the condition is FALSE)

You left out the last argument, so that when Designer is not David, you get FALSE. To leave it blank use this:
=IF(Designer="David","619"&"-"&"555"&"-"&"5555","")

**Pete_UK** · 06-11-2020, 08:41 PM

You can avoid the FALSE result by doing this:

=IF(Designer="","",IF(Designer="David","619"&"-"&"555"&"-"&"5555"))

but if you have more than one designer then it would be better to set up a table of names and phone numbers and use a VLOOKUP function.

Hope this helps.

Pete

**chubbychub** · 06-11-2020, 08:48 PM

Thank you 6stringJazzer and Pete_UK. Both worked, and about the name ranges, i just have too many name ranges now, and since i only have 1 designer, this will do. Thank you both again.

**Pete_UK** · 06-12-2020, 04:44 AM

Glad to help, and thanks for the rep.

Pete

if conditional format, then a phone number

LinkBack

Thread Tools

Rate This Thread

Display

if conditional format, then a phone number

Re: if conditional format, then a phone number

Re: if conditional format, then a phone number

Re: if conditional format, then a phone number

Re: if conditional format, then a phone number

Thread Information

Users Browsing this Thread

Similar Threads

For Format Phone Number

[SOLVED] Format for Phone Number - Won't work

[SOLVED] Phone number format - reference post (Formatting Textbox to type phone numbers only)

Conditional formatting for specific phone number format

Format a Phone Number

how do I add phone number format as a permanent custom format?

Format A TextBox For A Phone Number

Bookmarks

Bookmarks

Posting Permissions