Hello!
I've been working on creating a financial worksheet all night and am ready to cram glass into my eyes since I keep running into a brickwall when it comes to finding the right formulas for what I need. I've attached the worksheet for your expert review.
I am trying to figure out how upon entering a person's net income per pay period and then selecting the pay period (via dropdown lists in cells B9 and B10), their income will calculate correctly (in cells B10 and D10). I'd like to avoid using the dropdown lists I made that occupy those cells (B10 and D10).
PLUS, I have fields for Extra Income and I pretty much have the same dilemma there. Ultimately, a couple's total combined monthly income should be displayed in cell c12.
Also, I don't have any macros running on this sheet...why does the MS Excel Macro warning window popup?
ONE LAST THING: How can I make it so that all a person has to do is tab from one editable field to the next without tabbing to the next cell in a column outside the worksheet.
I am so very thankful for your help!
Respectfully yours,
Jonathan
Hey everyone,
I'm using Excel 2010 and I want to write VBA code for excel that will return the income statement from stockhouse.com on a sheet called "IncomeStatement" from the ticker symbol entered in d6 on a sheet called "Imput".
So basically if I enter GOOG d6 and then click my command button tied to VBA I want it to retrieve the income statement for google from:
http://www.stockhouse.com/tools/?pag...ubnav%3Dincome
and enter it into the "IncomeStatement" sheet.
I know it would probably be easier to download some addon but I'd like to get around that if possible.
Thanks a ton for any help anyone could offer.
Hi All,
On Sheet1 I have 2 cells one has the date 1-mar-09 and the other has 7-mar-09. I need to find this range on Sheet2 which has all the dates for the year in ColumnA and then total the amounts found in Sheet2!ColumnB for the specified date range. Is this possible without VB?
Thanks,
Leanne
I am a treasurer of a sports club and would like to use Excel to prepare and
print Balance sheets and year end statements of income and expenditure.
I am trying to find out a way to enter a stock ticker into any cell on my spreadsheet, and excel to automatically pull the financial information from the web. I can do this one stock at a time through a web query but would like to be able to insert a ticker and get that companies information.
Thanks for the help.
I plan to open a G/L chart of accounts table in one workbbook.
In a second workbook I plan to set up an income statement template. To begin I will keep it simple. Column one is name.
Column two the amount summed from the second workbook containing the G/L table.
What formula do I use in the cell of my income statement template when the value I wish to sum is represented by more than one G/L account? In otherwords let's say I need to sum the financial data in column G when the G/L account number in column A is one of 5 possible account numbers. I have tried sumproduct but it doesn't seem to allow for a list of G/L accounts.
e.g.
Sum the Sales Income for sales accounts 4000, 4002, and 4020 into cell J20.
Sum the value from the monthly sales column (G) if the account number in column (A) has the value of Account# 4000 or 4002 or 4020 ( these values happen to be strings ) and put the sum into my Income Statement workbook corresponding cell (J20).
Thanks for your help
Pinny
Good afternoon all,
I am trying to determine if, in a sumproduct statement, it is possible to use a 'contains' function.
I have attached a sample spreaddie. One column has a list of entries, some of which contain the word "Merlin" (Merlin from East, Merlin from West, etc), and some which do not. I want to add the entries that contain "Merlin" where advice has been provided. So far the only way I can see of doing it is to add each possible entry to the statement:
=SUMPRODUCT(--('Central MALT enquiries'!$C$2:$C$19="Merlin - PPD")+('Central MALT enquiries'!$C$2:$C$19="Merlin from East")+('Central MALT enquiries'!$C$2:$C$19="Merlin from West")+('Central MALT enquiries'!$C$2:$C$19="Merlin from South East")+('Central MALT enquiries'!$C$2:$C$19="Merlin from Central")+('Central MALT enquiries'!$C$2:$C$19="Merlin from North")+('Central MALT enquiries'!$C$2:$C$19="Merlin"),--('Central MALT enquiries'!$D$2:$D$19="Closed - Advice provided"))
This is getting horrendously unwieldly, and is going to get worse as we add more Merlin options.
Any help or advice will be gratefully received.
Thanks
Steve
I need an example of a multi business segment income statement for use in
studies at Ohio State.
I need an example of a multi business segment income statement for use in
studies at Ohio State.
hey everyone.
I am working on a Pro Forma Income statements for a business. I am an entrepreur, not a finance guy. Here is my issue
I have to give Net Income before Taxes, Taxes, NOL, and NI after taxes
i have these broken out as
Net Income Before Taxes
-100
-100
50
200
350
(This is EBT - earnings before taxes)
Taxes
0
0
17.50
70
122.50
(These are the Taxes for each year at 35%)
NOL
0
100
182.50
112.50
0
(Net Operating Loss is the loss of th prior year and can build up)
Net Income after Taxes
-100
-100
-150
50
165
(Net Income)
I want to figure out a way to do this with IF statements. If there is a Tax then check it against the NOL if the NOL can cover the tax do so and subtract the amount from the NOL. If it can cover some do the same and still subtract the secondary amount from NI...
I can't figure out how to do this. i asked a friend and he said that these message board were where everyone Excel Ninja hangs out!!! Just what i need!!!
Please Help!! If this doesnt make sense let me know?? i have to do 20 quarters!!! and don't want to do it by hand, cause it is gonna change ALOT!
Thanks Again!
