find command with in if command

**volkanozerk** · 07-03-2008, 03:52 AM

Hello,

Please note the forum rules which require formulae and code to be wrapped with code tags. You've taken the trouble to format the size of the formual and make it bold which is unnecessary.

Please edit the post.

Rgds

Hallo!!!

I want to use "search" formula with in "if" formula, but I have a problem,this formula is wrong and give me "#VALUE!" message!

=IF((FIND("normal";A3)>0);"normal";IF((FIND("outbound";A3)>0);"outbound";IF((FIND("delivery";A3)>0);"delivery";IF((FIND("case";A3)>0);"case";IF((FIND("invoice";A3)>0);"invoice";"")))))

Can anyone help me, what is my mistake???

**rylo** · 07-03-2008, 04:48 AM

Hi

Try this one.

=IF(ISNUMBER(FIND("normal",A3)),"normal",IF(ISNUMBER(FIND("outbound",A3)),"outbound",IF(ISNUMBER(FIND("delivery",A3)),"delivery",IF(ISNUMBER(FIND("case",A3)),"case",IF(ISNUMBER(FIND("invoice",A3)),"invoice","")))))

rylo