| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
assigning a value to a cell
Ok here is my senario:
I have a student roster with NAMES, NUMBERS, CODES, ETC. I would like to assign the number 1 to each cell in the NAME column that has any type of text in the cell. If there is no text then I would like to assign the number 0. Exmpl: Column A Column B Joe Schmo 1 Tina Turner 1 George W. 1 "No Text" 0 Shizam 1 "No Text" 0 Balthazar 1 Total = SUM(B1:B7) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| insert date | Excel Worksheet Functions | |||
| Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
| Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
| Dates of a Day for a month & year cell formulas | Excel Discussion (Misc queries) | |||
| cell color index comparison | New Users to Excel | |||
Threaded Mode
