Hope this isn't a duplicate, but my previous post never appeared:  I have a
running spreadsheet.  I only want a figure to show in I42 if I40-I41 is
greater than zero.  What is the correct formula?

MSN Investment Portfolio offer this feature. I understand that returns for
short term investments are projected over period of one year. Formula takes
into account daily price variation  of share.

I have a spreadsheet with about 20 columns of data, 3 of which are
long-winded array formulas. I have some conditional formats and simple IF
functions in the other 17 columns. I would like to keep the sheet calc to
auto, but this makes entry slow because of the 3 columns of arrays. ...

I have a woorkbook with multiple sheets (100+) which I need to analyse. I
need to combine all the worksheet data into one worksheet to be able to
manipulate.
All worksheets have the same table format but all contain different numbers

I have a working LOOKUP function in a spreadsheet referencing another page,
but when I copy it, or even retype it in the other rows, it returns the #N/A
error. The only difference that I can see is that for some of the other rows,
there are 0 amounts- could that be messing it up? ...

I have a about 6000 rows and 15 columns of data. (imported from the web
weekly by a macro)
My problem is to update the last date, wich I sort out by using Autofilter.
This givs me about 100 rows needed to be updated with information from

I NEED TO CHANGE POSITIVES VALUES TO NEGATIVE IN A LOT OF CELLS. HOW CAN I
ACCOMPLISH THIS WITHOUT DOINT IT ONE BY ONE. THANKS FOR YOUR HELP.

I would like to add a column of numbers, but some of the cells contain a
range ($800 - $1000) in them. Is there a formula / function, or do I need to
split up the ranges.

AT THE END OF THE PAGE I NEED TO PUT ONEMORE ROW AND IT WONT LET ME BUT I CAN
PUT A FOOTER IN ????????

Can anyone advise me how to autofill formulas which will take into account
the data is from different sheets please?  
I have several sheets I am wanting to pull data from as a summary sheet, but
at the moment I am having to manually type in the formula for each sheet in

I am doing a Darts score sheet in excel 2003. I have "game scores", "game
shots", "game average", "games played", "(sum)total scores", "(sum)total
shots", "(sum)total average", improvement increase\decrease percentage, and I
have even done a "bar chart". What I can't work out is ...

Here is the formula I've tried that isn't working:
­=concatenate(text(=$c$17-time(1,45,0),"hh:mm"),"­",text(=$c$17-time(1,15,0),"hh:mm"))
Is it possible to put these two formulas together? Basically, I need the
time to look like 07:15-07:45. These times pull off of cell C17. If C17 ...

I'm working on a attendance and vacation worksheet. The fist tab is a
summary of the other 4 tabs. This very similar to Micosofts tracking
templete1.I'm having trouble with summing multiple worksheet with a if then
statement. Here is what  I have so far,

I  have been working with vlookup tables for a while now but when I started a
new one with some new date from another source, it stopped working.  It will
not return values that I ask it to lookup.  The date is both numerical and
text.  I have sorted the date in ascending order.  ...

i have a column containing numbers, every other row there is an empty row, i
would like to copy the cell from above with the opposite sign to that empty
row, how can i do that with a formula or macro. So that i don't have to do
that one by one. Thanks a lot.