Home Register Members List Search Today's Posts Mark Forums Read

Go Back   TechFuels Forum > Software > Applications

Reply
 
LinkBack Thread Tools
jedichickhas1
Junior Member
 

jedichickhas1 is offline  
Old 01-26-2009, 04:48 AM
  #1 (permalink)
Excel formula question

Hi all,

I have a question about excel - I've been trying to get this to work for awhile now and can't figure it out. In my spreadsheet, I have a cell a2 with a number in it. In b1 I have another number (row 1, b-h have different #'s).

b2 = a2*b1.

Now, if I copy (ctr+insert) b2 to b3 = the calculation changes from a2*b1 to b2*c1 - which is not what I want.

I want a2 to always be the cell used - so if I copy (ctr+insert) b2 to b3 it should be a2*c1.

How do I do this?
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel's Formula jordan Everything Else 1 11-22-2008 04:48 PM
Asus Striker II Formula Motherboard fuankla Motherboards & Memory 0 07-24-2008 06:26 PM
Asus Rampage Formula Motherboard fuankla Motherboards & Memory 0 07-24-2008 06:19 PM
ASUS Crosshair II Formula Motherboard lamkin.jiod Motherboards & Memory 0 06-03-2008 10:26 AM
ASUS Maximus Formula chips vandana43 CPU & Components 0 03-10-2008 01:22 PM


All times are GMT +1. The time now is 07:03 PM.

Powered by vBulletin® Version 3.8.2
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.3.0
Copyright Techfuels -->
SEO by SubmitEdge


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151