financials

Hello, The UK has earnings brackets for income tax. Income tax bands ABC1Income tax bracketTaxable income fromTaxable income to2Basic rate (20%)Personal allowance£50,270.003Higher rate (40%)£50,270.01£150,000.004Additional rate (45%)£150,000.01£99,999,999,999.00 The "personal allowance" is...

Dear VBA Masters, I'm doing my first steps in VBA and I am stuck for days now with something that might have a simple solution. I have built a Solver macro, that is running and attached to a button in a sheet named "Consolidated Financials". It helps me to optimize some financial parameters in...

Hi All, Here is what I am trying to do. I have a formula in cell E9 in tab TOTAL FINANCIALS. This formula is an IF statement that will result in either 36, 48, 60, or 72 based on what a user selects in a drop down box (cell C11) and a date (cell C9) in a separate tab called FINANCIALS. (I...

Hey Guys, I've got a pivot table infront of me and just wondering if this is possible. Pivot table columns go as: Mechanic - Brand - Pack - Account I need all of these as they are. The next column is months. After this I have financials. I want to create a conditional format where...

I am working with data in PowerPivot that includes period, location, line description, and $ amt. I also want to calculate a % of net sales (net=Sales less returns) for each line below, with respect to the period# and Store location: Period Store Desc Amt VVV 1...

Hello, I need to SUM sales for the current month, up to the current week. In cell A1 I store the current fiscal week. In B1 I store the current month. I've tried a lot of ways to accomplish this. Week to date and Year to date were easy enough, but I can't figure out how to dynamically define...