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.
Excel IF equation
Name: mladams Date: August 21, 2006 at 06:32:54 Pacific OS: Excel 2003 CPU/Ram: Intel 2.4GHtz 1Gig RAM
Comment:
I'm using Excel 2003 and would like to know if there is any way to use an OR function along with the IF function. An example would be: IF(B2=1 OR 2,3,4) I have far to many conditions and I may have to rethink my approach but I thought I would see if this is a possibility.
Name: Jennifer SUMN Date: August 21, 2006 at 06:44:27 Pacific
Reply:
You'd need to do a nested IF. IF statements are If this this true, then do this, ELSE do this.
A Nested IF is the way to go.
Life is more painless for those who are brainless.
0
Response Number 2
Name: Michael J (by mjdamato) Date: August 21, 2006 at 23:10:52 Pacific
Reply:
You don't need a nested If statement, there is a operator for the OR operand.
=IF(OR(B2=1,B2=2,B2=3,B2=4),"true","false")
Michael J
0
Response Number 3
Name: Jennifer SUMN Date: August 22, 2006 at 15:47:36 Pacific
Reply:
Oops. I stand corrected. :)
Life is more painless for those who are brainless.
0
Response Number 4
Name: Michael J (by mjdamato) Date: August 22, 2006 at 16:24:36 Pacific
Reply:
No problem I had used the AND statement for the first time earlier that day. When I saw this message I figured there had to be a similar OR statement and checked the help file.
Summary: 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 ...
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: I need some help creating an IF statement in Excel. If there is text in (G19) then I would like it so that (T19) produces a result if (S19) meets the criteria of: if (S19) <=150 than 1.2, if (S19) ...
0 
