Excel Formula Help (basic) 2

[nervous2]

I have a spread sheet we use for mailers with addresses.

3 columns in the spread sheet indicate which mailer we will be sending out indicated with either a "Yes" or "No"

I would like to put a small code system on the label which I can tell our receptionist that if the label has a "*" that means mail our mailer 1 or mailer 2 or 3 etc.

How can I create a formula that would say if column "P" states "Yes" then in empty column "Q" fill cell with "*" if column "P" states "No" then in empty column "Q" leave blank.

Thank You

 

[SkipVought]

Hi,

Assiming that you are in row 2...
[tt]
Q2: =if(p2="Yes","*","")
[/tt]
if column "P" states "Yes" then in empty column "Q" fill cell with "*" if column "P" states "No" then in empty column "Q" leave blank.



Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[xlhelp]

=IF(P2="Yes",CHAR(42),"")

I don't particularly care about apathy

 

[nervous2]

Thank guys that worked!

One question regarding CHAR(42) (How woudl i know that this represents a "*"?

 

[SkipVought]

Check ASCII in help.

BTW, having an ASTERISK in data is a potential for problems, as ASTERISK is a wildcard for searches. So it becomes VERY DIFFICULT in the event that you have to FIND all of them.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}