excel-formula

Choosing Parameter In Excel

I have a datasource that poplulates my sheet from sql server. There is a parameter to refresh the data. Can I have the choices come from a drop down menu on another sheet? ...

Calculating an array of values in C# (Formula convert from Excel)

Hi all, I'm currently building a semi-complicated calculator which is basically a conversion from an Excel spreadsheet I've been provided. I've nailed most of it but there's a part in the Excel spreadsheet where multiple calculations occur between 6 rows and 7 columns, but the issue is that the calculations happen in no particular orde...

Conditional Self-Referencing Formula (only execute if cell value == "")

Hello, here is my problem with the execution of an excel formula. These are the requirements: I have several lines in an excel sheet. At the end of each line there is a field called "Month". If someone enters new values in this line, the current month should be inserted. If the values get modified, the month must not be changed. T...

Point to a relative other Sheet in Excel

I'm trying to find a way to from a Cell get the data from a cell in the Sheet that lies to the Left (down in the tray) of the current Sheet. I know how to call to other sheets via =Sheet1!A1 But now I need something best explained with =Sheet[-1]!A1 Any ideas? ...

Optimizing multiple-crtieria IFs

Folks, I'm performing array calculations that are taking a long time to complete. I'd like to optimize my formulas some more. All of the formulas are of the same nature - they perform some high-level function (Average, Slope, Min, Max) across a column of values. However, not all cells in a column are included in the array. I use mul...