How would my if statement look like if I my logical test can be more than 1
value?
For example, if cell A1 = "apple" or "oranges", then return 1, else return
2.  How can I show the apple or oranges logical test in equation form?

To reduce the size, since it runs very slow, my subbordinate save it in
Excel Binay workbook, without my knowledge. Some of the formula does not not
work, so I asked her to change the xls extention in the formula into xlsb,
and it works.

I am trying to keep track of peoples' email addresses that are not receiving
my messages. Currently, the cell range A1:L1 contains my headings, Cells
A2:A126 contain the Contact ID numbers. Currently I have 126 Contacts. Column
K is my status Column. I want to create aconditional ...

Is it possable to write a Program in Excell to Predict the Lottery winning
numbers, I am sure a lot of us have  given this some Thought any Ideas?

Please help:
I have an Excel 2007 formula problem. I think the problem that I have
requires an IF function and I've been trying to put it together but it's a 7
part formula and they keep canceling each other out somehow. I have several

Can someone help me with a formula to compute the time difference
between two columns containing "Start Date & Time" and "End Date &
Time". I want to compute my time difference in hours, so I use (End
Date & Time - Start Date & Time)*24. When I compute this time

I am trying to figure out how to insert a formula in a footer so that when
the page is printed the current date and time will appear but i also want to
include an as of date.  My as of date will always be the monday prior to the
print date.

Hi, I am trying to workout how to import multiple values from a ssheet into
another sheet. I am using postcode to import all suburbs matching the
postcode into another table.  The sheet i am importing from has multiple
rows, 1per suburb with postcode and suburb in each row?

I am trying to link my worksheets and it was working and then after I saved
it and reopened it the next day it doesn't seem to be working now but the
formulas are still there but when I enter new information it's not being
reflected on the other sheets.  I'm assuming that I'm ...

What I need to do is have a project start date and an end date and a
duration of days. We work a 4 day work week here and I need to not count
Friday (Sat or Sun) in the duration of the projects. I just need a correct
end date for the projects.

I have a different worksheet than the one i am going to describe.  I'm just
going to make this one an example.
i would like to have my tab have all the information.  But on my second (or
more) tab i want it to display specific information.  Say i wanted it like a

i need to count the sum of values in column A if column B <> "sent"  ... sent
is text written into the cell
thanks in advance.

In Excel 2003, I was able to highlight the contents (select a range of cells)
and then send via email from Excel.  When I did this, the contents of the
worksheet (everything that was highlighted / cells selected) would go out in
the body of the email (Outlook).  How do I do this ...

i have a column of dates. i'm trying to count how many in that column fall
within a particular date range.
for example, column A has 15 rows of dates.
i need the sum of which dates fall between 5/19 and 5/22 for example.

I am attempting to do an AVG function w/ the following formulas. And every
time I do it gives me the #DIV/0! error message.  None of these are blank nor
do they have zero totals so I'm not sure why I keep getting the message. Do I
have the IF formulas entered incorrectly????