View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
kittycatvet kittycatvet is offline
external usenet poster
 
Posts: 1
Default need to subtract one cell from each cell in a row

I have a range of cells and want to subtract a value from each cell. Can I
do that without having to do each one individually? Here is a very shortened
example of what I am doing. I need to make the start value 0. To do that, I
need to subtract 2 from each of the cells. Is there a way I can subtract 2
from each cell in the row?

Start Value 5 min 10 min 15 min ............... 120
min
2 2 4 4
.................11 ml