From: AFLmath on 1 Apr 2010 17:06 I am sure that this question has been asked and answered. I am creating a worksheet for my class. I have a value in cell b2( I want use this value thru out the sheet). Let say b2 = 10 b c d 3 5 6 8 4 3 7 1 I want to subtract each value from b2(10). How can I do this without doing it manually?
From: Lars�ke Aspelin on 1 Apr 2010 17:44 On Thu, 1 Apr 2010 14:06:04 0700, AFLmath <AFLmath(a)discussions.microsoft.com> wrote: >I am sure that this question has been asked and answered. I am creating a >worksheet for my class. I have a value in cell b2( I want use this value >thru out the sheet). Let say b2 = 10 > > b c d >3 5 6 8 >4 3 7 1 > >I want to subtract each value from b2(10). How can I do this without doing >it manually? Does that mean that you want the following end result (if not, explain what result you do expect). b c d 3 5 4 2 4 7 3 9 This may be accomplished by the following command sequence Put 1 in any spare cell, say F10 Select cell F10 (that has the value 1) Copy Select cells B3:D4 Paste Special > Operation = Multiply Select cell B2 (that has the value 10) Copy Select cells B3:D4 Paste Special > Operation = Add Clear cell F10 (the spare cell) Hope this helps / Lars�ke
From: JLatham on 1 Apr 2010 17:46 Refer to the cell via its absolute address: $B$2. That way as you 'drag/fill' formulas using it around on the sheet, it won't change. To subtract a value from it =$B$2  4 or even another cell reference =$B$2  D3 "AFLmath" wrote: > I am sure that this question has been asked and answered. I am creating a > worksheet for my class. I have a value in cell b2( I want use this value > thru out the sheet). Let say b2 = 10 > > b c d > 3 5 6 8 > 4 3 7 1 > > I want to subtract each value from b2(10). How can I do this without doing > it manually?

Pages: 1 Prev: Formula helplookup? Next: Cell Formats  Limit # of characters 