aspose file tools*
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
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
 
Don't get me started about those stupid light bulbs.
 
subject: Regarding multiple IF's using "OR"