subtract a column by a number

  • Thread starter Thread starter quickcur
  • Start date Start date
Q

quickcur

I have a excel sheet,


Name Salary

Tony 1000
JOhn 2000
Gary 3000


I want to subtract all numbers in column "salary" by 10. So that

Name Salary

Tony 990
JOhn 1990
Gary 2990

How can I do it?

Thanks,

qq
 
Put 10 in a "free", that is, empty cell somewhere. Copy that cell. Select
the cells that you want to adjust. Then select Edit | PasteSpecial and use
Operation = Subtract.

Regards

Trevor
 
The workers would be happier if you used Operation=Add. <g>

Bill

Put 10 in a "free", that is, empty cell somewhere. Copy that cell.
Select
the cells that you want to adjust. Then select Edit | PasteSpecial and
use
Operation = Subtract.

Regards

Trevor
 
Back
Top