LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
why cant i subtract one cell from another? Awes1 Excel Worksheet Functions 3 April 2nd 08 04:45 AM
subtract from a cell if another cell is occupied Keith Excel Discussion (Misc queries) 3 March 28th 07 03:07 AM
subtract from numeric cell when alpha cell is occupied Keith Excel Worksheet Functions 0 March 28th 07 01:04 AM
Subtract text in one cell from another? BigIan Excel Worksheet Functions 3 July 7th 05 09:21 AM
How to subtract value in one cell from aanother cell value? freder Excel Worksheet Functions 2 June 25th 05 09:50 AM


All times are GMT +1. The time now is 08:00 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"