I have a spreadsheet that I'm working on and I need help with a formula in Cell M7. I have attached a copy of the spreadsheet for your viewing. In this Cell, I need it to automatically change based when Cell when Cell K4 meets certain thresholds. For example if K4 reaches $600, then M7 should reflect $600x1=$600 + O4 + Q4. If it reach $800 M7 should reflect $800x2=$1600 + O4 + Q4 and so on. I have broken down below what I would like M7 to reflect for each threshold.
I have inputed the formula into the example spreadsheet I was trying to work with and it might give you an idea of what I'm trying to acomplish. Any help would be greatly appreciated.
What I want Cell M7 to reflect as the amounts meet certain thresholds:
(K4$600)x1=$600+O4+Q4
(K4$800)x2=$1600+O4+Q4
(K4$1000)x3.5=$3500+O4+Q4
(K4$1200)x4=$4800+O4+Q4
(K4$1400)x4.5=$6300+O4+Q4
(K4$1600)x5=$8000+O4+Q4
(K4$1800)x5.25=$9450+O4+Q4
(K4$2000)x5.5=$11000+O4+Q4
(K4$2200)x3.75=$8250+O4+Q4
(K4$2400)x4=9600+O4+Q4
Thank you ahead of time for any help!
Semisi
Bookmarks