Regarding multiple IF's using "OR"

[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

[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

In article <[email protected]>,
[email protected] says...
>
> 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
>
>
> --
> sunita_shaw
> ------------------------------------------------------------------------
> sunita_shaw's Profile: http://www.excelforum.com/member.php...o&userid=32227
> View this thread: http://www.excelforum.com/showthread...hreadid=520298
>
>