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

• 0
• Question
• Updated 11 months ago
I need to make an autofill based on the number obtain from the substrack of 2 fields.

Ex.
1.-
Field "A" quintitie assure 100,000
Field "B" % charge              .4%
Field "C" total charged           400
Field "D" comission paid      0%

2.-
Field "A" quintitie assure 100,000
Field "B" % charge              .6%
Field "C" total charged           600
Field "D" commision paid    .1%

So field E I needed to be

Field "A" times  x points (If  in field B-D .4%= 3 points, If  .5%=5 point. If .6%= 7 points , all with commission considered)

1.- 100,000 X  3 (.4%- .0%= .4%) = 300,000
2.- 100,000 x   5 (.6%-.1% = .5%) = 500,000

• 214 Points Posted 11 months ago

• 0
• 72,488 Points Perhaps you mean this for the formula for [Field E]

var number X = ([Field B] - [Field D]) * 1000;

[Field A] * \$X

• 214 Points 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

• 72,488 Points If([Cuota]>=0.001 and [Cuota]<=0.00348),1,
.....
• 214 Points 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

• 72,488 Points I was just giving you a part of a formula and showing how to use the "and".

I don't know what you want the whole formula to do.  If you just want it to do that one thing, then just close the bracket.

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

• 214 Points great thank you