Does anyone know fomula that looks at C2. If that cells has a name, then in
D2 (which is where the forumla will be) is automatically inserts 5.50.

Cathy

More detail needed about "has a name". Is there a list of valid names
somewhere on your worksheet (if so, where)? Will any text in C2 be enough to
qualify as a name?

Rick

"Cathy" wrote in message
...
Does anyone know fomula that looks at C2. If that cells has a name, then
in
D2 (which is where the forumla will be) is automatically inserts 5.50.

Cathy

Have you considered looking in the help index for

IF

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Cathy" wrote in message
...
Does anyone know fomula that looks at C2. If that cells has a name, then
in
D2 (which is where the forumla will be) is automatically inserts 5.50.

Cathy

Hi Cathy,

Suppose that C2 either contains a name or is empty, then the formula would be
=IF(C2<"",5.5,"")

You didn't say what you want if the C2 is empty so I have the formula
displaying a blank. I you want 0 the replace the last "" with 0.

--
Cheers,
Shane Devenshire


"Cathy" wrote:

Does anyone know fomula that looks at C2. If that cells has a name, then in
D2 (which is where the forumla will be) is automatically inserts 5.50.

Cathy

Dear Cathy, enter this formula in cell D2.
=IF(c2="","","5.50")

"Cathy" wrote:

Does anyone know fomula that looks at C2. If that cells has a name, then in
D2 (which is where the forumla will be) is automatically inserts 5.50.

Cathy