07-26-2004, 07:19 PM
|
#1 |
|
Vice Admiral
  
Join Date: Dec 2000
Location: Cali, but missing Hong Kong and Texas
Posts: 4,782
   |
EXCEL question
I have a question for you peoples!!!
So I'm using excel, and I'm wondering if there is a function in excel that lets me input a letter into a cell, but outputs a number. Please TELL ME HOW TO DO SO!!! need massive help with this project!!!
__________________
Life is like toilet paper, long and useful! The stars at night, are big and bright *clap 4x* deep in the heart of TEXAS! |
|
|
|
07-26-2004, 07:21 PM
|
#2 |
|
captain awesome
Join Date: Jan 2003
Posts: 7,054
|
so let's say you enter B, you want that same cell to show the number 5?
|
|
|
|
|
07-26-2004, 07:33 PM
|
#3 |
|
Chief of Naval Operations
 
Join Date: Feb 2001
Posts: 11,733
|
If you input "A" into A1 and in B1 you have the formula =CODE(A1) you will get a 65 in B1.
__________________
stay low... keep moving... |
|
|
|
|
07-26-2004, 08:02 PM
|
#4 | |
|
Admiral
Join Date: Mar 2001
Location: Utah
Posts: 5,420
|
Quote:
__________________
And closer... |
|
|
|
|
|
07-26-2004, 09:39 PM
|
#5 |
|
Vice Admiral
Join Date: Dec 2000
Location: Cali, but missing Hong Kong and Texas
Posts: 4,782
|
yeah thats what I'm going for...but the thing is...with putting an equation in the cell, and refering it back to that cell, it would make it circular equation.
it has to be user friendly, so I have to make it so the user inputs a Letter, and a number comes out. this is what I need E=1, D=4, C=3, B=4, A=5 the person inputing the information is reading straight off a paper, and putting it on the excel Spread Sheet. So to reduce error, I need to have it so the output in a number. The reason I need numbers there, is so that I can calculate stats from those numbers. |
|
|
|
|
07-27-2004, 12:31 AM
|
#6 |
|
Lieutenant Commander
 
Join Date: May 2002
Location: Oregon
Posts: 581
|
how about function SUBSTITUTE.
|
|
|
|
|
07-27-2004, 12:43 AM
|
#7 |
|
Vice Admiral
Join Date: Dec 2000
Location: Cali, but missing Hong Kong and Texas
Posts: 4,782
|
I've tried that one...but it won't work since it relies on text that is currently there!
anywho...I think I found a way around my problem! So I can move on.... but I have another question... say I wanted to do a weighted average. which means, I've taken the averarage of a list of numbers...but there are some outliars that are skewing the information. problem, my average is 1.75, and any numbers of my list that are 1.68 plus or minus away from my average I want to not count it towards my weighted average. How to accomplish this matter? |
|
|
|
|
07-27-2004, 01:31 AM
|
#8 |
|
Vice Admiral
Join Date: Dec 2000
Location: Cali, but missing Hong Kong and Texas
Posts: 4,782
|
edit...screw that last question I have
I'm using the countif function on excell...but the thing is, the if criteria doesn't accept cell references...does anybody know of another function that does a count if that accepts cell references!!!! |
|
|
|
|
08-01-2004, 06:59 AM
|
#9 |
|
Captain
Join Date: Sep 2000
Location: You can’t get there from here, USA
Posts: 1,797
|
why dont you just jet them enter all the data tehn use the find and replace feature of excel then do your calculations
|
|
|
|
|
08-01-2004, 09:23 PM
|
#10 |
|
Commander
Join Date: Jun 2000
Location: Costa Mesa, CA
Posts: 1,295
|
for your first question you can use IF... THEN...
|
|
|
|
|
08-02-2004, 01:40 AM
|
#11 |
|
Vice Admiral
Join Date: Dec 2000
Location: Cali, but missing Hong Kong and Texas
Posts: 4,782
|
AHHA...I found out that the function COUNTIF does use cell reference
you can bust it out like so... =COUNTIF(">"&A1) friggin excell!!!! |
|
|
|
Linear Mode
