| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
HELP!!!!
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
HELP!!!!
Try something like this:
B1: =IF(LEN(A1)=1,"ZBN","") Does that help? *********** Regards, Ron XL2002, WinXP-Pro "nick" wrote: 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
HELP!!!!
Thanx a lot...it helped.
"Ron Coderre" wrote: Try something like this: B1: =IF(LEN(A1)=1,"ZBN","") Does that help? *********** Regards, Ron XL2002, WinXP-Pro "nick" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
