Hi ...
I have an Excel question, if you don't mind.
I can't get the following to work. Can anyone see why not?
=IF(AND(F3=1,E3>2.1,E3<5.1),$J$2,0-(E3-1)*$J$1,IF(AND(F3=1,E3>5,E3<7.1),$K$2,0-(E3-1)*$K$1,IF(AND(F3=1,E3>7,E3<9.1),$L$2,0-(E3-1)*$L$1,IF(AND(F3=1,E3>9,E3<12.1,$M$2,0-(E3-1)*$M$1,IF(AND(F3=1,E3>12,E3<20.1),$N$2,0-(E3-1)*$N$1)))))
Where,
J1=100, J2=95
K1=75, K2=71.25
L1=50, L2=47.50
M1=30, M2=28.50
N1=15, N2=14.75
Thanks in advance ...
I have an Excel question, if you don't mind.
I can't get the following to work. Can anyone see why not?
=IF(AND(F3=1,E3>2.1,E3<5.1),$J$2,0-(E3-1)*$J$1,IF(AND(F3=1,E3>5,E3<7.1),$K$2,0-(E3-1)*$K$1,IF(AND(F3=1,E3>7,E3<9.1),$L$2,0-(E3-1)*$L$1,IF(AND(F3=1,E3>9,E3<12.1,$M$2,0-(E3-1)*$M$1,IF(AND(F3=1,E3>12,E3<20.1),$N$2,0-(E3-1)*$N$1)))))
Where,
J1=100, J2=95
K1=75, K2=71.25
L1=50, L2=47.50
M1=30, M2=28.50
N1=15, N2=14.75
Thanks in advance ...