View Single Post
  #2   Report Post  
JE McGimpsey
 
Posts: n/a
Default

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.