Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Character as a Number
Is the way to do this with If statements or does someone have a better idea
(I sure hope so!)? A character in column A = 0; char in col B=2; char in col C=4; char in col D=6 and so on. In a row, only one character can be put in a row in one of the four columns, and the same character must always be used consistently. The row is then summed and a percentage taken from another cell. For example, in Row 2, there's an 'x' in col C - the sum of the row would be 4. Clear? (as mud); in Row 3, there's an 'x' in Col D so the sum of the row would be 6. Thanks!!! Jani |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Character as a Number
=(MATCH("*",A1:E1,0)-1)*2
for the first four cells in row 1 No IFs were needed -- Gary''s Student - gsnu200805 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Character as a Number
I don't understand the formula and would appreciate it if you would tell me
how this works. It is so close. What I'm finding, however, is that when an * is put in a cell in a row the formula works fine but it allows another * to be added to the same row and that can't be allowed. How would this formula be changed to accomodate that? Would it be to count the *'s and if more than one have a statement displayed. Appreciate your help very much!!! Jani "Gary''s Student" wrote: =(MATCH("*",A1:E1,0)-1)*2 for the first four cells in row 1 No IFs were needed -- Gary''s Student - gsnu200805 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Character as a Number
I got it figured out! Thanks!
"Gary''s Student" wrote: =(MATCH("*",A1:E1,0)-1)*2 for the first four cells in row 1 No IFs were needed -- Gary''s Student - gsnu200805 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Character as a Number
Preventing more than one cell from being filled can be done with Data
Validation -- Gary''s Student - gsnu200805 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is the first character a number or letter | Excel Worksheet Functions | |||
Cvt number to character | Excel Discussion (Misc queries) | |||
Number of character in one cell. | Excel Worksheet Functions | |||
remove cr character from a + number and change number to - 159cr | Excel Worksheet Functions | |||
Why does last number of a 16 character number always change to 0? | Excel Discussion (Misc queries) |