# \$25

1. ### If formula for determining a fee

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 -...
2. ### Delaying revenue recognition by Month

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...
3. ### Calculate Pivot Field

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...
4. ### Text and Data in a single Cell combo

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...
5. ### Combine text and date in a cell

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...

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back