For example I have $500 for June operating expense. How do i annulaize
it? Or how do I estimate year to date expense.
Thanks

I am sure that I used to be able to get two rows of print into one cell.
I have tried sub and super script, easy for one row, then it cancels that
when you try to put the second row in.
Is there a way please?

I am trying to keep track of company allowances.  
A                         B                          C                      
D                        E
Name               Hire Date                 eligibility date     allowed

I am looking to have implement a simple inventory formula but i'm not
sure how to get it done. Do I require an IF statement? Macro?
I have 4 variables
Total Ordered = TO

I would like the number that is displayed in row M15:L15 to display in row
M15. Only one cell would have a number in it.
Thanks for your help

Any ideas on how to shorten the following:-
Thanks
Sandy
=IF(OR(C7=0,D7=0,E7=0,F7=0,G7=0,H7=0,I7=0,J7=0,

My data are arranged so that each row (or column, transposed) consists of a
question, and the data are 1-5 point (strongly agree to strongly disagree)
words (or values).  I want a table that has each question in a row and each
of the values in a column.  I've worked for 3 hours, ...

Hi again,
How to write in this code by
1) making the workbook to be set in Manual Calc. mode, before population of
template sheets,

I have a worksheet *(sheeta) with a list of activities with "Open" and
"Closed" dates.
In worksheet B, I have A2:A50 I have
          A                         B

I have the following range A1:G44 and the values in cells:
A2 = 4B
A5 = 8L
B2 = 1L

my question is as follows, i'll try to explain it using a current
situation I've had.
I've created a semi-numerological list (numbers with other
characters), consisting of the following data:

Thank you in advance for your help. I have this array formula in cells L2:L52
=COUNT(1/FREQUENCY(IF(LEFT('[Spares Quotes List V22
26Apr2007.xls]All'!$A$2:$A$5003,4)=RIGHT($A8,4),IF('[Spares Quotes List V22
26Apr2007.xls]All'!$P$2:$P$5003<>"",MATCH('[Spares Quotes List V22

I have dragged website addresses from AOL Favourites over to Excel. However
their description (name) rather than their web address is showing. How can I
display the website address also

Please can anyone advise me why the following formula is not acceptable and
is coming up as "the formula you typed contains a error"?
The cell for the answer is formated as General
=SUMIF(B4:B8,"BANK",J4+J8)

i have tried to put a chunk of code ... but i m unable
to make it fit as per my problem. can u help me out!
My scenario is as follows:
PunchDate DateIn Timein  DateOut  Timeout  Shift  Dept  Reg  LCh  OT