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

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()