I have a spreadsheet with twowork sheets.
On the first are a number of (about 5) If statments per row with abou
300 rows.
The second has selective references to the first sheet.

This is my formula: =IF(Data!B2:B21=K54,"ZONE2","ZONE1") and k54=PINE
AND PINEL is found IN THE RANGE B2:B21 ;however, this fromula return
ZONE1
Can some one help me?

What formula would give a value of a last negative value in a range? I want
to calculate a pay-back period from a cumulative cash-flow or a cash-flow.

Is there anyway to convert a file with columns back to comma delimited
--
Message posted from http://www.ExcelForum.com

I'm trying to call a dll from within Excel 2000. This is what I?m doing:in
cell B1 I include this code: =CALL("MyDll";"Mult";"JJJ!";C1;D1)
in C1 and C2 there are any integers.
what I get is the FALSE word in cell B1.

I need to join or combine multiple worksheets from multiple workbooks rather
than having a number of workbooks open.
What is the easiest way to do this?
Roger

Is it possible that as soon when you select a cell that has validation using
a list, you see all the options?
Txs in advance
Michael

Is it possible to use the comparing side by side facility on the vertical
rather than horizontal plane.
Thanks in anticipation.

I know this is an old question. Is there a way to display
zero fields as blanks? I know I can do this with and If
(x=0,""...etc,  but then if this cell is used in a
subsequent formula, such as a sum, I get a VALUE error.

Is there a way in excel to rotate the contents of the cell to 180 degrees?
Thanks

The formula below I have used in my worksheet is what I have copied
from Mr. Pearson's site http://www.cpearson.com/excel/distribdates.htm
(Many thanks to him and his great site), however it is based on the
Start and End date being 15-Jan-00 and 12-Jun-00 in Cel B17 and C17

Could anyone help me with the following question:
I have a spreadsheet with a column of cells that are coloured (colored
in purple whilst a project is incomplete but which are then coloure
white again when the project is finished.  I have another column i

I have number data in two columns as follows
Cell A1    1234
Cell B1    056789
Require 1234056789

Assume I have the following data that tabulates the sale of widgets b
each salesperson for the firt half of the year (6 months):
*******       JAN  FEB  MAR  APR  MAY  JUNE
Richards        10   15    20     25    30     35

Is there anyway to prevent a pivot table row from being split onto two
pages when printed?