HELP!!!!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I want to populate a default value ZBN in B1 if there is any value in A1
(any char). How do i do this????? Any help wld be appreciated. Thanx
 
Try something like this:

B1: =IF(LEN(A1)>=1,"ZBN","")

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro
 
Thanx a lot...it helped.

Ron Coderre said:
Try something like this:

B1: =IF(LEN(A1)>=1,"ZBN","")

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Circular reference help! 4
Help! 4
Date Formula 4
Change rows to columns for similar records 3
excel 3
Auto populate cell 3
using formula or similar to paste maximum value in cell in excel 2 4
Concatenate and include trailing blanks 5

Back
Top