I have this spreadsheet and i need to insert a IF statement that says if the location is Inner, then it would be the current amount multiplied by 15% however, if the result is is less than 3000 then it is 3000 but if it is more than 5000 then insert 5000 but if the result is between 3000 and 5000 then it is 15% multiplied by the current amount. I need to repeat the same thing for Outer which will be the current amount multiplied by 20% and also Fringe which will be the current amount multipled by 40%
Location Current Amount
Inner 276.2
Outer 279.31
Inner 690.5
Inner 552.4
Inner 883.84
Inner 552.4
Inner 552.4
Outer 328.6
Inner 690.5
Inner 911.46
outer 410.75
outer 410.75
Inner 2458.18
Outer 2762
Fringe 2762
Fringe 2762
Fringe 2762
Fringe 2762
Location Current Amount
Inner 276.2
Outer 279.31
Inner 690.5
Inner 552.4
Inner 883.84
Inner 552.4
Inner 552.4
Outer 328.6
Inner 690.5
Inner 911.46
outer 410.75
outer 410.75
Inner 2458.18
Outer 2762
Fringe 2762
Fringe 2762
Fringe 2762
Fringe 2762