Regarding multiple IF's using "OR"

  • Thread starter Thread starter sunita_shaw
  • Start date Start date
S

sunita_shaw

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
 
Search XL help for 'OR' (w/o the quotes). It will lead you to the OR
function that looks like OR(logical1,logical2,...)

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Zero in the cell instead of some junk date 2
If, And, Or Formula 2
Using SUM to calculate values of cells containing formulae 4
If A1=HR then... 6
Mulitple "IF/OR" statments 3
Excel Formula 7
Conditional Formatting More than 3 with Formula 9
sum of multiple IF statements 9

Back
Top