Hi. I am currently stuck at the moment to work out a formula to return me back the right levels
I have asset levels which I need to return back the asset number.
Below is my table
Fee Levels
$0 - $100m 3
100m+ to 1bn 4
1bn+ to 10bn 6
10bn + 8
If my asset level is $1m, then in column B I expect to return $1m, column C/D/E will be 0
With this formula if the asset level is $120m, then I expect the formula will return $100,000 column B, $20m column C & C & E is 0
Basically im trying to look for the right formula to use in cell B2, C2, D2 & E2
file attached - this is so challenging so hope someone can see what I am trying to do
Bookmarks