In a commission report i would like my formula in j5 to be something like
this...
if e5 = $3.00 up to $3.14 then j5 = .38*d5,-h5
if e5 = $3.15 up to $3.24 then j5 = .43*d5,-h5
if e5 = $3.25 up to $3.34 then j5 = .46*d5,-h5
if e5 = $3.35 up to $3.44 then j5 = .49*d5,-h5
if e5 = $3.45 up to $3.54 then j5 = .52*d5,-h5
if e5 = $3.55 up to $3.64 then j5 = .56*d5,-h5
if e5 = $3.65 up to $3.74 then j5 = .59*d5,-h5
if e5 = $3.75 and up then j5 = .62*d5,-h5
I hope this makes sense and i appreciate all the help i have received!