$25

I am currently trying to figure out how to do the formula to auto determine a fee. Basically, I have a cell with the total costs of a project, "E44" In a new cell, I want to put the fee determined on that total. Fee structure is a follows: $1 - $25,000 = 6% $25,001 - $100,000 = 5% $100,001 -...

Hello, I am trying to create a model where a portion of revenue is consumed each month starting on the contract start date. The amount of consumption each month would be an input and could be changed if required. In the below example 85,000 is total revenue, 25,000 is consumed for 3 months. On...

I have three columns in my pivot table. Status, Goal, and Forecast. My rows are Outlook Status (Booked, To Go, At Risk, etc). I want to calculate per status, the % of grand total goal based on forcasted revenue. Say I have 5 orders Goal Forecast Order 1 $5 $10...

I want to write a formula and function which includes text and date as a desired result shown below in bold Desired Result Total Expenditures as of December 31, 2017 $100,000 The expenditures are keyed in a different sheet Monthly Expenditures Column A...

I want to write a formula and function which includes text and date as a desired result shown below in bold Desired Result Total Expenditures as of December 31, 2017 $100,000 The expenditures are keyed in a different sheet Monthly Expenditures Column A...