On Fri, 30 Sep 2005 14:25:03 -0700, "jerry"
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