Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Microsoft Excel IF Statement
Name: dmurfitt Date: March 31, 2005 at 01:03:13 Pacific OS: Win XP Pro CPU/Ram: P4
Comment:
Hi,
I was wondering if someone could help me get an Excel IF statement right. I am making a test, and I need to convert the raw score into a standard ten. Basically, I need a formula that says IF the raw score is 0 to 3 then the STEN is 1. If the raw is 4 then the STEN is 2. If the raw is 5 or 6 then STEN is 3 etc...
Is there any way to do this? The raw score is in cell A15 for example, so it will be IF A15 =
I have managed to get the if statement with true and false working, but not with multiple values.
Name: chnos Date: March 31, 2005 at 22:28:06 Pacific
Reply:
hello, shortest and simply way could be a vlookup make like: 1 1 2 1 3 1 4 2 and so on so u can ezly match exact number to exact value without having a big big if(xx;xx;if(xx;xx;if...). Of course u can have it too with a if(A1<"max value";"max matching";if A1<"step5";"matching 5";if A1<"step4"...... and so on). Hope it helps...!
0
Response Number 2
Name: dtech10 Date: April 1, 2005 at 12:53:41 Pacific
Summary: Could I please obtain some help creating an Excel IF statement, considering the following parameters: - There is a date in cell A1 - The statement will appear in A2 - If the date in A1 is more than 30...
Summary: What is the formula for an IF statement to hilight any value or text, if that value appears more than one time in any given column? Using conditional format in excel ...
0 
