Feb 13 2019 06:09 AM
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 answer is 32.65
Feb 13 2019 07:18 AM
That could be
=C4*LOOKUP(C4,{0,15,23},{2,1.65,1.4})
Feb 13 2019 01:35 PM
Thank you!! Did exactly what I needed done.