HELP!!!!

N

nick

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
 
R

Ron Coderre

Try something like this:

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

Does that help?

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

XL2002, WinXP-Pro
 
N

nick

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...
 
Top