Write a VBA sub procedure called addNumbers that adds all numbers from the first given number to the last number (see a sample run below). Your sub procedure should allow the user to enter the first and the last number and display the sum of numbers form start last inclusive.
Skill Set Required...
I want to export data to excel (which i can export only one contact, not all contacts and without customization) and edit whatever i want and then import it back to my phone..
Hope am clear and thanks in advance
I have a column with a bunch of numbers in it, then i also have several cells with functions that use that data as precedents.
Every time I sort the data differently the functions become wrong because they take the value from the cell location rather then where the value is after the sort...
ok here's the dilemma:
I have an excel file with a lot of data (>2000 rows) with columns A, B, C, and D. column A has a unique # for each row, and D1=B1-C1, D2=B2-C2, etc.. I wan't a formula that would give me a string of the A values of the D's >0, each separated by a space, a comma, and a...
I work at a company that basically has a master of addresses that we file claims to and every time we get a new client they give us a code pertaining to a specific address which we in turn have to search every address to find our code in our system to tie it. I was wondering if excel had like a...
I am trying to create an annual leave excel spreadsheet. I would like to have column B as the annual leave taken, such as 8 hours. I would like to have column C as hours remaining for the whole year. Column C would start with a total of 308 hours. Any help appreciated, thank you
Not a traditional quiz, I need to make an analysis spreadsheet/database that assigns different numeric values to each question (i.e. if someone answers that their age is 30, the rest of the quiz would have different values than if they said they were 50).
I am looking to create an Excel spreadsheet for my budget. I need it to be able to download my current balance from my bank, but the bank web page kicks me out after a few minutes because I go idle. This in turn alters the URL for my data query, and I can no longer download my balance. How can I...
Hello, I am pretty clueless when it comes to Excel.
Is there any spreadsheet base files around that would do what I want?
One column would be an amount of money that is gained from a job. Then three other columns would be percentages of that amount (At the moment 30, 30, 40). Then a total for...
between two whole numbers? If I had a set of 50 values that range between 1 and 100 how do find how many values I have between from the set of 50 values that fall between 20 and 30?
between two whole numbers? If I had a set of 50 values that range between 1 and 100 how do find how many values I have between from the set of 50 values that fall between 20 and 30?
let say i want to use the formula =LN(B1/B2) for cell G
instead of typing =LN(B2/B3) and then =LN(B3/B4) for each cell, is there a faster way of doing this?
Two questions pelase , I am lost and my text book is vague.
Cost of Equity for common stock formula for excel I know the following :
Dividend in year 1 = $8, growth = 6%, floatation costs percentage of stock
price = 11.4%, and the current stock price = $58.
Cost of Debt formula I know the...
Two questions pelase , I am lost and my text book is vague.
Cost of Equity for common stock formula for excel I know the following :
Dividend in year 1 = $8, growth = 6%, floatation costs percentage of stock
price = 11.4%, and the current stock price = $58.
Cost of Debt formula I know the...
I am a newbie and have come across a formula like this:
=IF(AL:AL>0,"Returned",IF(AK:AK>0,"Released",IF(AJ:AJ>0,"Complete",IF(AB:AB>0,"In Process",IF(B:B>0,"In House",IF(#REF!>0,"Dist. Centre",IF(A:A>0,"Incoming","")))))))
Can all the gurus out there please explain to me in layman term what is...
I'm trying to graph of column of data which is around 260000 data points. It definitely exceeds the limit, but is there a way I can possibly grab every 5th data point instead and use it for the graph? I'm not that great in excel, some step by step instructions would be helpful. Thank you.
How could I make this formula work only across, on different horizontal levels?
=G7-(C7+B7)
I want to be able to make it automatically work for whatever row it's on, like G6-(C6 +B6).