Forum Discussion
Formula HELP
Need help setting up a formula for Excel. C4<15 then C4*2 C4>15 BUT <23 then C4*1.65 C4>23 then C4*1.4 NEED THESE (3) MULTIPLES TO DEVELOP (1) ANSWER C4 IS 19.79 so in cell E4 the ans...
That could be
=C4*LOOKUP(C4,{0,15,23},{2,1.65,1.4})Thank you!! Did exactly what I needed done.
