I am fairly certain there is a way to do this and I am not finding it.
D David Biddulph Mar 26, 2009 #2 The function is called negation. The Excel symbol is - The formula is =-A1, and copy down and across as necessary. An alternative is to put -1 in a spare cell, copy, then select your range of cells, and Edit/ Paste Special/ Multiply (or Divide).
The function is called negation. The Excel symbol is - The formula is =-A1, and copy down and across as necessary. An alternative is to put -1 in a spare cell, copy, then select your range of cells, and Edit/ Paste Special/ Multiply (or Divide).
