|
|
#1
07-15-2014, 11:07 AM
|
|||
|
|||
Tiered Fee Calculations
I have to perform a tiered fee calculation as follows:
$0 - $1,000,000,000 = 0.535% (Cell K1) $1,000,000,001 - $2,000,000,000 = 0.485% (Cell K2) $2,000,000,001 - $3,000,000,000 = 0.435% (Cell K3) Over 3,000,000,001 = 0.385% (Cell K4) Net Assets = 2,000,452,222 (Cell C1) The fee will be charged in each designation. How can I write in a single cell how to calculate the fee based on the table above? Is it an IF statement nested? 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Running Calculations in MS Word | ha2014 | Word | 1 | 02-05-2014 05:03 PM |
 Table Calculations, VBA
|
SuzeG | Word VBA | 7 | 12-15-2013 07:12 PM |
| How to do Calculations In a Text Box? | SteveF | Word | 4 | 09-27-2013 08:34 AM |
|
Can I do calculations with times?
|
cubsfan_1 | Excel | 1 | 01-14-2010 06:55 PM |
|
Having problems with Duration calculations.
|
bgane | Project | 1 | 03-20-2006 06:36 AM |
Windows 8 
Office 2010 64bit
Threaded Mode