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!

Try...

=LOOKUP(E5,{3,3.15,3.25,3.35,3.45,3.55,3.65,3.75}, {0.38,0.43,0.46,0.49,0.
52,0.56,0.59,0.62})*D5-H5

Hope this helps!

In article ,
"Dave O." wrote:

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!