About Us

Thanks a lot Ron and Dave. have a great one!
Jerry

"Ron Rosenfeld" wrote:

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

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
count function problem	nkidd	Excel Worksheet Functions	4	July 7th 05 08:55 PM
Lookup function problem (kg)	greencecil	Excel Worksheet Functions	3	July 1st 05 04:54 PM
Problem with function "Worksheet_Change"	konpego	Excel Worksheet Functions	0	June 23rd 05 05:46 AM
Problem adding a range using Sumif function.	vrk1	Excel Worksheet Functions	2	June 22nd 05 06:05 PM
Need a ISWorkday Function -- Any Ideas	Mark	Excel Worksheet Functions	5	March 29th 05 01:58 AM

Menu

About Us