|
Posted to microsoft.public.excel.worksheet.functions
|
|
|
An "IF" function question
=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!
|