Regarding multiple IF's using "OR"

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
 
T

Tushar Mehta

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
 
Top