Two Laptop Bag*
The moose likes General Computing and the fly likes Regarding multiple IF's using Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCM Java EE 6 Enterprise Architect Exam Guide this week in the OCMJEA forum!
JavaRanch » Java Forums » Engineering » General Computing
Bookmark "Regarding multiple IF Watch "Regarding multiple IF New topic
Author

Regarding multiple IF's using "OR"

sunita shaw
Ranch Hand

Joined: Apr 06, 2003
Posts: 45
Please help...
I came across this problem and kindof stuck up
The query is

IF(ISNUMBER(MATCH("Project Planning",$C$3:$C$3)),IF(K3<>"",K3,I3))

I also want to check if its not "Project Planning" then is it "System Test"
if its not "System Test" then is it "Regression Testing" and then check the second IF statement i.e IF(K3<>"",K3,I3)

How can I check for multiple using OR statement before IF(K3<>"",K3,I3) is executed
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: Regarding multiple IF's using "OR"