create formula. 1 field constant and another field varies by inpu.

G

Guest

need a formula that takes the 1st number from a field that is inputted by me
and multiplies it by 2nd number i input into another field and then divides
by 100. I dont want extra columns to show. I want to put the number in the
field and when i press "enter" key or "tab" key to move to next cell, that
previous field to calculate and insert the answer into that field. example is
as follows:

A2 82
A3 woulb be "my input"*A2/100= "answer"

need help ASAP


Thanks Brian
 
T

travis.conway

A3=(A1*A2)/100

Would that not work? Pending A1 is the field you are putting data into?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create a web site link from a part link and a data field in access 2003 1
Need help with formula!!!! 2
Pivot Table question: Creating a new field that calculates thedivision of one data field by another 4
Formula Query 9
Macro to copy value in field and insert it into filter 2
Create default text based on another text field 1
Looking for the correct excel formula 2
Access date in 1 field and day in another 3

Top