=IF((C6>0)*AND(S24=50,60),M6/5,M6/6)...This function works as I desire,
however I want to add a third option where S24 would =70 and M6/7. An error
occurs stating too many arguments enterd. Can some help me??

1    1000
2    1500
3    900
4    2000

I have a manufacturing/production costing worksheet in which you enter a Part
Number, setup time, setup cost/hr, production time, production cost/hr,
overhead cost/hr (which is constant) and number of parts.  Given that info,
it calculates the cost per part.  We currently have ...

I know this is "conditional" and I know that excel limits to 3 conditions -
but specific question...
Can you write a macro to include several conditions?
This is what I want...

I am trying to count the number of matched pairs by rows of data an
place this into a chart.  Please see the screen shot example and manua
solution.
With the data sets:

If column A and column B both contain a list of names, what formula con I put
in C1 so the result indicates if B1 exists anywhere in column A?

Can anyone please tell me how to change a fraction like 14 12/1
(being 14 stone and 12Ibs - I'm british!) to red when it is
negative number only. And remain black when it is a positive
I realise it is probably easy to most but to me at 55 it seem

I would like the cell numeric entry to appear in "( ###)" format (with
parenthesis)
ex:
   (9) or (4.5)...

This is my second post and the first post yielded another equation that
didnt work. Im trying to add up vacation days starting in jan and
ending in dec. It needs to only sum the total days taken up until the
current days date. The problem Im having is I cannot get the SUMIF

I have a column (called Tract Number) that contains a column with a 11
character number (BTW, it really isn't a number, if that helps), such as this
one: 7-5-029-001.  The number will ALWAYS have this format, and will ALWAYS
contain 11 characters.

I have a spreadsheet with 3 named ranges:-
File_Name (name of file)
Version (file version)
Date_Val (date when version was saved).

I have a spreadsheet that returns a series of appointments based on a
start date.
Name    StartDate        Lesson 2        Lesson 3    etc.
Name1    26-Jan-05        2-Feb-05        9-Feb-05   

I have an Excel question that I hope you can help me with. I know in the past
I have seen this done, but can't remember how to do it.  When I create a
pivot table and have all the info listed there, how do I get that list to be
on individual sheets?  For example, I have a list of ...

How can I write this expression so that my answer is not #VALUE?
I'm working with dates, and I want to count only the dates in columns H, J,
& L if they fall between the dates entered in F1 and H1.  
IF H5 or J5 or L5 is >F1 and <=H1 count as 1.  

I got your macro command a long time ago to change the cell pointer. I pasted
it in "ThisWorkbook" on my Personal worksheet. The Macro works when you put
the code in a worksheet. Can you please modify the code so if I copy it in my
Personal worksheet, it will work everytime I ...