Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Regarding multiple IF's using "OR"

 
sunita shaw
Ranch Hand
Posts: 45
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic