A positive numberical value is in F6 when i get the Value error

In the instance when the one cell contains total and the other cell contains
something other than "", the appropriate calculation is executed.

However, in the instance when the text"total" in not found and yet there is
a numberical value(returns true) in the other cell, the value error is
displayed.

Jerry



"Dave Peterson" wrote:

> 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
>