On Fri, 30 Sep 2005 14:25:03 -0700, "jerry" <jerry@discussions.microsoft.com>
wrote:

>
>I am trying to make sure that the row, that meets two criteria return true
>and then multiply by a percentage.
>
>=IF(AND(SEARCH("*Total",C5),F6<>" "),F6*0.03," ")
>
>this returns a VALUE error.
>
>what am i doing wrong, can i not use the search funtion within an IF AND stmt
>
>thanks
>Jerry

SEARCH is probably returning the VALUE error by not finding Total in C5.

Use this instead:

ISNUMBER(SEARCH("*Total",C5))

Also, you probably want to use null strings rather than spaces in checking F6;
and also in returning the value_if_false from this function; so:


=IF(AND(ISNUMBER(SEARCH("*Total",C5)),F6<>""),F6*0.03,"")


--ron