| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
An "IF" function question
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text "comparison" operator for "contains" used in an "IF" Function | Excel Worksheet Functions | |||
| Question about "Find" function in Edit menu | Excel Discussion (Misc queries) | |||
| change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
| "Disk is Full" add-on question to "Can't reset last cell" post tod | Excel Discussion (Misc queries) | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
Hybrid Mode
