posted 18 years ago
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