Hello everyone,
I hope someone can help me about my vba in access
how to write the code for this condition
a = 0 to 5
b = 5 to 10
c = 10 to 15
d = 15 to 20
e = 20 to 25
f = 25 to above
if G is equal to a then
H is = 0
if G is equal to b
H = G minus 5 multiply by 0.1
if G is equal to c
H = G minus 10 multiply by 0.2
if G is equal to d
H = G minus 15 multiply by 0.3
if G is equal to e
H = G minus 20 multiply by 0.4
if G is equal to f
H = G minus 25 multiply by 0.5
Thank
I hope someone can help me about my vba in access
how to write the code for this condition
a = 0 to 5
b = 5 to 10
c = 10 to 15
d = 15 to 20
e = 20 to 25
f = 25 to above
if G is equal to a then
H is = 0
if G is equal to b
H = G minus 5 multiply by 0.1
if G is equal to c
H = G minus 10 multiply by 0.2
if G is equal to d
H = G minus 15 multiply by 0.3
if G is equal to e
H = G minus 20 multiply by 0.4
if G is equal to f
H = G minus 25 multiply by 0.5
Thank