Is it possible to create a function that will convert text to value,, for
example,, if B1 is BLANK then C1=0, if B1 contains text then C1 =1 Thanks in
advance for any help, I have been trying to figure this out all day!

I'm assuming by the way you worded this question that you consider a
numerical entry to be "text" (more specifically, non-blank). If that is the
case, then this formula (placed in C1) will probably do what you want...

=IF(B1<"",1,0)

Rick


"volunteer" wrote in message
...
Is it possible to create a function that will convert text to value,, for
example,, if B1 is BLANK then C1=0, if B1 contains text then C1 =1 Thanks
in
advance for any help, I have been trying to figure this out all day!

Actually,, I need ,,, IF B1 is BLANK, then C1 needs to be 0, if it is NOT
BLANK (it would have a word such as TICKET in it) then I would need C1 to be
1,,, does that make sense? thanks for your help!
"Rick Rothstein (MVP - VB)" wrote:

I'm assuming by the way you worded this question that you consider a
numerical entry to be "text" (more specifically, non-blank). If that is the
case, then this formula (placed in C1) will probably do what you want...

=IF(B1<"",1,0)

Rick


"volunteer" wrote in message
...
Is it possible to create a function that will convert text to value,, for
example,, if B1 is BLANK then C1=0, if B1 contains text then C1 =1 Thanks
in
advance for any help, I have been trying to figure this out all day!

=if(isblank(b1),0,"message")

"volunteer" wrote:

Actually,, I need ,,, IF B1 is BLANK, then C1 needs to be 0, if it is NOT
BLANK (it would have a word such as TICKET in it) then I would need C1 to be
1,,, does that make sense? thanks for your help!
"Rick Rothstein (MVP - VB)" wrote:

I'm assuming by the way you worded this question that you consider a
numerical entry to be "text" (more specifically, non-blank). If that is the
case, then this formula (placed in C1) will probably do what you want...

=IF(B1<"",1,0)

Rick


"volunteer" wrote in message
...
Is it possible to create a function that will convert text to value,, for
example,, if B1 is BLANK then C1=0, if B1 contains text then C1 =1 Thanks
in
advance for any help, I have been trying to figure this out all day!

maybe this isn't possible with Excel 2000 because when I use that function it
just puts a 1 in the cell in the C column,, I need the cell in C to be 0
until I put a WORD in the corresponding cell in column B, with the function
below it just puts a 1 in the cell and doesn't change it when I change column
B,,, really confused,, what am I doing wrong?thanks for your help

"ASA" wrote:

=if(isblank(b1),0,"message")

"volunteer" wrote:

Actually,, I need ,,, IF B1 is BLANK, then C1 needs to be 0, if it is NOT
BLANK (it would have a word such as TICKET in it) then I would need C1 to be
1,,, does that make sense? thanks for your help!
"Rick Rothstein (MVP - VB)" wrote:

I'm assuming by the way you worded this question that you consider a
numerical entry to be "text" (more specifically, non-blank). If that is the
case, then this formula (placed in C1) will probably do what you want...

=IF(B1<"",1,0)

Rick


"volunteer" wrote in message
...
Is it possible to create a function that will convert text to value,, for
example,, if B1 is BLANK then C1=0, if B1 contains text then C1 =1 Thanks
in
advance for any help, I have been trying to figure this out all day!

If the formula is giving you a 1 in the column, then it isn't the formula
which ASA suggested below. Don't try to retype it. Copy from here and
paste into the formula bar.
--
David Biddulph

"volunteer" wrote in message
...
maybe this isn't possible with Excel 2000 because when I use that function
it
just puts a 1 in the cell in the C column,, I need the cell in C to be 0
until I put a WORD in the corresponding cell in column B, with the
function
below it just puts a 1 in the cell and doesn't change it when I change
column
B,,, really confused,, what am I doing wrong?thanks for your help

"ASA" wrote:

=if(isblank(b1),0,"message")

"volunteer" wrote:

Actually,, I need ,,, IF B1 is BLANK, then C1 needs to be 0, if it is
NOT
BLANK (it would have a word such as TICKET in it) then I would need C1
to be
1,,, does that make sense? thanks for your help!
"Rick Rothstein (MVP - VB)" wrote:

I'm assuming by the way you worded this question that you consider a
numerical entry to be "text" (more specifically, non-blank). If that
is the
case, then this formula (placed in C1) will probably do what you
want...

=IF(B1<"",1,0)

Rick


"volunteer" wrote in message
...
Is it possible to create a function that will convert text to
value,, for
example,, if B1 is BLANK then C1=0, if B1 contains text then C1 =1
Thanks
in
advance for any help, I have been trying to figure this out all
day!

I GOT IT!!!! Thanks for all of your helps!

"volunteer" wrote:

maybe this isn't possible with Excel 2000 because when I use that function it
just puts a 1 in the cell in the C column,, I need the cell in C to be 0
until I put a WORD in the corresponding cell in column B, with the function
below it just puts a 1 in the cell and doesn't change it when I change column
B,,, really confused,, what am I doing wrong?thanks for your help

"ASA" wrote:

=if(isblank(b1),0,"message")

"volunteer" wrote:

Actually,, I need ,,, IF B1 is BLANK, then C1 needs to be 0, if it is NOT
BLANK (it would have a word such as TICKET in it) then I would need C1 to be
1,,, does that make sense? thanks for your help!
"Rick Rothstein (MVP - VB)" wrote:

I'm assuming by the way you worded this question that you consider a
numerical entry to be "text" (more specifically, non-blank). If that is the
case, then this formula (placed in C1) will probably do what you want...

=IF(B1<"",1,0)

Rick


"volunteer" wrote in message
...
Is it possible to create a function that will convert text to value,, for
example,, if B1 is BLANK then C1=0, if B1 contains text then C1 =1 Thanks
in
advance for any help, I have been trying to figure this out all day!