I have a spreadsheet that has many SUM formulas that change on a monthly basis. Instead of manually changing each formula every month I want to create a...

What the spreadsheet figures out is how many pounds of product a person averages per hour of labor. Below are the formatting and formula I'm using.. I13 is...

i would like to have a set of prices round up or down to the nearest ninth. for example, 1.15 turns into 1.19. 2.41 turns into 2.39

Loan template for repayment over 101 months showing capital amount and interest

I have used the following formula to replace N/A with 0, where there is no value to return. =IF(ISNA(VLOOKUP(D18,'KOTC_Customer Price List '!A:E,2,FALSE), 0...

I'd like to either remove the #div/0 or change it to say "N/A" in this equation: {=AVERAGE(IF(C102:C1140,C102:C114,FALSE))} Can some excel guru help a poor...

How do I include formulas from source database in the filtered results

I have just done an advanced filter and copied the results to another sheet, the data has been copied over with just values, is there any way of copying the...

If I divide my worksheet up into 2 panes, how do I perform "unsynchronized schrolling" Thanks

The ____ qualifier references the Total row in the table. Thanks for your help.

Hello, Is there a way (addin utilities or otherwise) to cause the formula in a cell to display the values for the component references making up the...

I'm trying to display information in LOG LOG space. I can make the calculations, but displaying it as it would appear on Log paper is a problem. Any...

to duplicate this problem follow these steps: select F1 and click autosum button - use mouse to select e1-a1 - press enter select F2 and click autosum button -...

I need to generate a random list of the whole numbers 1-52 with no duplicates and no decimal places.

How do I reference a tab name in a cell?

MY OBJECTIVE IS TO CONVERT A REAL NUMBER (EG 71.30000) REPRESENTING DEGREES, MINUTES AND SECONDS (DD.MMSSS) TO DECIMAL DEGREES (DD.DDDDD) TO EXTRACT THE...

I am creating a Loan Amortization schedule and would like to configure it to autmatically populate the list of periods based on the number of periods in the...

i have a excel file with up to 12 worksheet tabs, its a controlled doc used to update current software revisions used by qc for verifying sw in cellphones. the...

Hello, I wonder if someone can help me with this: I'm trying to confirm a valid time entry in a form field, and if invalid, clear the entry and put the focus...

I found a bug in the Excel GCD function. I blogged about it he http://davidvs.blogspot.com/2006/04/bug-in-excel.html To summarize, try typing into a...