I have the following Columns (A and B) with binary output (1 and 0), such
that A and B would not both contain 1 but both could contain 0.  What formula
would I use in column C that calculates % change between cells D1 and E1 only
when there has been a 1 in A and followed by a 1 ...

I'm Looking to enter a date in one cell with a duration behind it so it comes
up in the other cell with new date.    Example
3-2-07 - 90 day duration -  6-2-07

Example:  Sheet1 has master data which is linked to various other 'working'
sheets in the same workbook.  In practice, the master data has to be moved
around regularly, using cut and paste.  Each time this happens, Excel moves
the reference in the 'working' sheet, which is not ...

Due the size restriction of the IF function, I have used the LOOKUP function
for my conditional formula.  It is yielding the results I want, but when the
criteria does not match, the result is the error #N/A.  Here is the formula I
am using:

I am trying to use the VLOOKUP function to lookup and return the combined
value of 2 separate cells.  Specifically, I want to use the VLOOKUP function
the VLOOKUP function to return the combined value of cells $Z2 (First Name)
and $AA2 (Last Name).   I used the following formula ...

I have to create a worksheet for a highway design class. I need to be able to
create a table between certain chainage stations.
example:
I need to create a table starting from 10+000 to 12+000 at 20 metre intervals.

I am trying to use an IF function with a VLOOKUP function to correct for an
#N/A result.  
The VLOOKUP formula I am using is
=VLOOKUP(A4,'[TRAVEL MANIFEST_Master.xls]Sheet1'!$A$2:$Q$66,8,FALSE).  

What formula can I use to end up with a blank cell,if the sum of all cells
equals 0
TNA Phil

I am looking for a formula that is very similar to sumif - except I do not
what to sum the values - i just want to display the value or text that is
contained in another cell on the sam row that the name is on.
for example:

how would i get the man hours to do a load.  I have 4 workers and it took
them 1:30 to load 1023 cases.

How can I best create blank cell value as the result of the Excel "IF"
sorksheet function?
That would be useful "Paste Special" a column or row of the results over an
existing column of entries, while skipping blanks, to over-write only the

I have tried using the following formula in linking two workbooks. How can I
retrieve information (numbers) from two different cells in the source
workbook? Neither will work.
Formula in cell D8:    =[Acct1MAS.xlsx]A!D8+G8

how do you count numbers in a row .. but onley the highlight one
eg:- 10 numbers in a row but 4 are highlight answer well be 4

Is there a way to conditionally format a cell to a color only if a referenced
cell is already conditionally formatted to a color. Ex; format cell A2 to red
if cell A1 is conditionally formatted to yellow?

How can I convert a checked checkbox into value "1" ? I created a checkbox
(via toolbar-Form)  in a cell. When I copy and special paste link that cell
to another sheet in the workbook, the value is "0" even when I check the
checkbox. What I want is to see an "1" when the checkbox ...