Forum Discussion
Creating an array
Hi! I am trying to set up a spreadsheet that takes the total $ amount of one cell, and gives me a figure in another cell, based on whether the $ in the first cell is less then, greater than, or ...
Hi Amy,
That could be
=D3*LOOKUP(D3,{0,25000,32001},{0.005,0.075,0.01})
in E3 and down.
Okay that is not working, it is only giving me the .5% total, I need it to give me a .5% if the total in column D is less than $25,000. If the total in D3 is in between $25,000 and $32,000, I need it to total the amount in D3 times .75%, and if the total in D3 is greater than $32,000, I need to total in E3 to be, D3 times 1.%
Hopefully that makes better sense!
I think Sergei may have had it right the first time, but there was one typo. I think the formula should be:
=D3*LOOKUP(D3,{0,25000,32001},{0.005,0.0075,0.01})
Oops... Yes, sorry for the typo
Amy, please check formula in attached file if it works with you
