Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

if function not giving results 1

Status
Not open for further replies.

CCNProjects

Technical User
Nov 4, 2005
64
CA
Hello,
I am using this formula to fill the blanks in a column based on values on an adjacent column.
=IF(C5 <> "",C5,B4)

Instead of the values, I get the formula itself (it becomes a string)

Would you please tell me why I can't make it behave?

Thanks.
 




Format the COLUMN as GENERAL.

Skip,

[glasses]Did you hear what happened when the OO programmer lost his library?...
He's now living in OBJECT poverty![tongue]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top