I calculated a XNPV on a series of cash flows. The cash flow in the first 27
years is zero and then there are positive cash flows for another 25 years.
The calculation read the first positive cash flow as if it were at time zero
instead of discounting it back 27 years. I ended up ...

Hi guys, need some help here...
I have 120 colums across, each representing a month.. (month 1-120).
Each month has a dollar value (starts off mostly negative, then whe
payback comes, number becomes positive).

how do I "hide" columns where I get the "+" and "-" and the numbered levels
at the a1 cell like if I used the subtotals function?

I am working a huge spreadsheet and want to be able to use a T-bar to move
around in the text. In essence if I am moving left in the grid I want to move
up or down using the T as my guide so that my columns and rows are in snyc.

I'm using Excel 2003.  I would like to create a formula in which X=7.5
I would like to be able to write the following formula: =IF(B6=X,7.5,0)
If I place an X in the cell then the value of that cell is 7.5  I hope
I explain this correctly

I am using a drop-down list for data validation in a column. Can I make the
drop-down list in another column dependent on the contents of the first
column?
Example:

So, Sheet1 Cell B2 I have =Data!A2, basically wanting to copy the value
from cell A2 on data sheet to cell B2 on Sheet 1.
Previously, I would use fill handle to drag down and cell B3 would then
populate to =Data!A3, B4 = Data!A4 etc.. and their corresponding values

I am trying to assign a specific value to a cell based on multiple
choices.
For example, cell A1 needs to be "A", "B", "C" or "D" (pay grades)
This value is based on what is contained in cell B1.

Hi guys, need some help here...
I have 120 colums across, each representing a month.. (month 1-120).
Each month has a dollar value (starts off mostly negative, then whe
payback comes, number becomes positive).

I want to type a name in one cell on a worksheet and have it appear in
another worksheet.  Basically, type one text entry and you get two - one in
one worksheet and one an another.
Any suggestions?

I'm using the tip on the attached link to highlight cells wit
formulas. At home it opens fine but at work a co-worked and I both ge
a macro warning saying there was a Macro V4 on the sheet.
Does anyone know why or an alternative to highlighting the formulas

Ok. I'm working with a customer who has two spreadsheets. She's tryin
to count the number of people based on there Lane and New Step.
She's has a section called Lane (which can be numbers from 1-6) and Ne
Step (which can be numbers from 1-19). Now the code is going to have t

I am trying to use an IF statement involving two arguments - IF Cell X
is = "blank" then bring back the SUM of Cells XX-XX BUT IF Cell X
[this is the same cell as the first reference] is = "non blank" the
bring back the SUM of Cells YY-YY.  Is this possible?  If so how woul

I am having an issue of special formats making lookups fail.  On 2 excel
sheets with data I need to merge, via lookup, both have multiple corrections
on them.  The problem lies in this, the corrections are done by using the
"Strike out" feature, which causes errors in the lookup. ...

I have a combobox in a worksheet, and the entries are populated from a list
of 365 items in another area of the worksheet.  
Only 354 entries are showing up.  I am using a named range to populate the
combobox, and I double-checked that the range is correct.