IF statement

[Cathy]

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

 

[Rick Rothstein \(MVP - VB\)]

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

 

[Don Guillett]

Have you considered looking in the help index for

IF

 

[ShaneDevenshire]

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.

 

[sanjay D.]

Dear Cathy, enter this formula in cell D2. (e-mail address removed)
=IF(c2="","","5.50")