i have a simple table: in the first column are the dates, in the second are
the exchange rates.
i would like to find the exchange rates of the last day of the months.
the problem is that rates are published only on business days, so for

I'm trying to do a formula for a conditionning formatting....How do I say
=IF cell a2 OR b2<2 AND c2 OR d2=1, then apply the formatting?
I have =IF(OR(A2<2,B2<2),(OR(C2=1,D2=1)))
But's it's reading all 4 situations and applying the formatting if any 4 of

I received an excel spreadsheet in which when I do Format/Cells or Ctrl+1
nothing happens. I can copy the data into another spreadsheet and all seems
OK. Any suggestions as to why Format/Cells dow not work on this specic
spreadsheet?

I have 10 columns:  A1:J1
I would like to deposit a value (actually, a formula) every "X
interval.  So if I specify "2", I would like to deposit this valu
every "2" columns in the array A1:J1.  If I enter "3", every 3 columns

I am only wanting to count the hours between two dates that fall on Monday
thru Friday.  In other words, I want to always exclude counting hours on
Weekends
The data is in the format of

I have tried many different formats and formulas and the worksheet will not
calculate the difference between two times formatted as follows.
 6/12/2006 8:03:14 PM     6/12/2006 8:08:55 PM    #VALUE!
              B8                                                C8

I'm trying to show corrections to an Excel spreadsheet and would like to draw
a red line through the information and change some numbers.  How can I use
tools like redline or insert corrections without deleting the old information?

Okay, I'm trying to link one cell (business expense - lunch) to anothe
section on the spreadsheet which is where they explain where, when an
with whom they had lunch.  
Once they enter the dollar amount for lunch is it possible for them t

ex. IF cell C2 is listed in column F need to state 'True' or 'False'.  Here
is what I typed, however, it is not working correctly.  Help!
=IF(C2=F:F,"true")

I am trying to look up a name and return a sum of all values in one column
associated with that name. There are between one and five values for each
name. I am only able to return one value for each name, rather than the sum
of all the values. Is there a way to look up all ...

i am trying to make a rollup sheet that users input Y or N depending on the
question for each column and i want a total "completed (Y)" to be displayed
below

I am trying to sum a column when it meets two conditions. I have tried the
following:
=IF('Service Request Log'!$B$4:$B$5000,$A189,SUMPRODUCT(--(LEFT('Service
Request Log'!M$4:M$5000,3)="asa")))

IN EXCEL, IN A GIVEN CELL, I HAVE INSERTED A FUNCTION.
I NEED THE RESULT TO BE POSTED IN ANOTHER CELL DESIGNATED BE ME IN WHICH I
CAN ADD ADDITIONAL FUNCTIONS AND SO ON.
THANK YOU

In workbook 1, I have a table with data from various companies:
                    Company x            Company y            Company z
apples                    
apples                    

I'm trying to lock only one cell by first unlocking the entire sheet, then
locking only the cell, and then protecting the worksheet.  However, when I do
this, it locks everything.  When I protect the worksheet it automatically
checks "Select Locked cells, and Select Unlocked ...