Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
I am working with an excel spreadsheet that has dollar values for different companies. i want to get a % difference for each company on multiple line items B7:B28. I found a formula the works for a single cell but i do not know how to make that formula work for the entire column and multiple columns beyond that.... any help? The formula that works is K7/C7-1. This gives me the correct value but only for that specific set of two numbers.
Name: DerbyDad03 Date: April 22, 2009 at 10:42:43 Pacific
Reply:
Are you asking how to find the % difference for each set of values in each row?
If so, just hold your cursor over the black box in the lower right corner of the cell that has your formula. Once it turns into a plus sign, click, hold and drag down the column. It will autofill the column, changing the row used in the formula as it goes.
BTW, the correct formula to find the % difference between 2 values is:
Summary: Is the data sorted just like your example or would the 790 be mixed in all over the place? Is 790 the only number you are looking for or will you be puliing in data from the other numbers at various t...
Summary: hi, i'm creating an excel worksheet for account receivables aging. However, im having problem with the if function regarding the computation of the number of days past due. Can you help me with the fo...
Summary: Hello! I'm using Microsoft Excel 2004 for Mac. I am using it to calculate my payroll. I have a cell that I need to calculate regular pay for the week (vs. overtime pay). So I need it to sum all ho...
0 
