What's in it when you get the error?

Maybe...
=IF(AND(SEARCH("*Total",C5),trim(F6)<""),F6*0.03, "")


jerry wrote:

F6 can contain either a blank cell ,negative numbers or positive numbers

"Dave Peterson" wrote:

What's in F6?

You may want to use an empty cell and try:
=isnumber(f6)

And I'd stay away from putting a space character in the cell. It usually makes
for trouble later on.

I'd use:

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



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

--

Dave Peterson


--

Dave Peterson