An "IF" function question

  • Thread starter Thread starter volunteer
  • Start date Start date
V

volunteer

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
 
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!
 
=if(isblank(b1),0,"message")

volunteer said:
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!
Click to expand...
 
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
 
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.
 
I GOT IT!!!! Thanks for all of your helps!

volunteer said:
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
Click to expand...
 
Back
Top