One way:
If you are entering your numbers in column A, say, then in column B
enter:
B1: =(A1*3)*(1-40%)
or, better,
B1: =A1*3*60%
copy B1 down as far as necessary.
In article ,
wbinfo wrote:
On a new spread sheet I am entering numbers and I would like them to be
multiplied and changed automatically. The formula is x*3 then less 40%.
Can anyone help me.
|