# Trying to figure out a formula

If Me.txtGross is 566.60 and txtMultiplier is 7.00% (datatype = number, double, percent, 2) what is the formula to come up with an answer of 526.94 ?

The human understandable (at least for me) is 566.60 x 93% but I can't figure out how to write the control source for the answer field.
###### Who is Participating?

Infotrakker SoftwareCommented:
You could also do this:

YourInputValue - (YourInputValue X (YourMultiplier/100))

566.60 - (566.60 x (.7/100)) = 526.938
0

Senior developer, analyst and customer assistance Commented:
It should be
(txtGross/100)*(100-txtMultiplier)
that is
(566.60/100)*(100-7) = 5.666*97 = 526.938
0

CIOCommented:
The direct method will be:

``````Me!txtNetto.Value = Me!txtGross.Value * (1 - Me!txtMultiplier.Value)
``````
Or, for the rounded value:

``````Me!txtNetto.Value = CCur(Format(Me!txtGross.Value * (1 - Me!txtMultiplier.Value), "0.00"))
``````
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.