make an autofill based on the number that shows another field.

Thank you for quick answer,

actually I want that B-d = .4 than to considered  3 points to multiply A
if  B-D= .5 then to considered 5 points multiply by A
if B-D= .35 then to considered only points 2 multiply By A 
if B-D= .6 then to considered points 7 multiply By A 

.35=1 
.4= 3
.5= 5
.6= 7

I want to make a relation between result and the points. I want to autofilled

Did you try the formula I suggested?

Please try the formula and if it is not working how you want please tell me the result is giving and the result you expected.

It worked but I want to give like a preset value for the points, perhaps I need to work to steps. 
Field E  which convert result from B-d. When ever I get .4% I want 3, when ever I get .6% I get 7 and so on. 
And then another field lets say F, which multply Field A times Field E

If you want to make a field for the points called [Points], then use

 ([Field B] - [Field D]) * 1000;

The then field for the final results would be

[Points] * [Field A]

Hi again Coach,

I tried to use this formula but it seems I am writing something wrong.

If([Cuota]=".35",1, [Cuota]=".6", 7)

where cuota is field B= .35 should come to 1 point, if cuota .6 then should come to 7 points.

I get this message

The expression [Cuota] on the left hand side of the operator "=" is of type number while the expression ".35" on the right hand side is of type text. The operator "=" cannot be used with these types of expressions.
You may need to do one of the following to fix the problem:

• Add a type conversion function.
• Choose a different operator.

try this

If(
[Cuota] = .35,1,
[Cuota]= .6, 7)

Thank you coach, it worked perfect.

Have nice day.

Hi again Coach,

Is it posible to have a range instead of a number? I tried this formula but think wrote it wrong. If between .001 and .00348 then have 1

 If([Cuota]>=0.001,[Cuota]<=0.00348),1

 If([Cuota]>=0.001 and [Cuota]<=0.00348),1,
.....

Soeey is not working, I get this massage!

Formula syntax error

There are extra characters beyond the end of the formula.

If([Cuota]>=0.001and[Cuota]<=0.00348),1