close
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 quot;enterquot; key or quot;tabquot; 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 quot;my inputquot;*A2/100= quot;answerquot;
need help ASAPThanks BrianA3=(A1*A2)/100
Would that not work? Pending A1 is the field you are putting data into?want to keep from having a 3rd column
全站熱搜