| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to quickly divide a cell by another cell in a different column but same row?
Example: Row -- A ---- B 1 ----- 1 -- =*A1*/2 2 ----- 2 -- =*A2*/2 3 ----- 3 -- =*A3*/2 4 ----- 4 -- =*A4*/2 How can I change the A1, A2, etc to something more general like AX/2 where X is the row that it is in? Thanks, and sorry if this is too basic, I don't know what it is called that I am trying to do. -- windbreak ------------------------------------------------------------------------ windbreak's Profile: http://www.excelforum.com/member.php...o&userid=30763 View this thread: http://www.excelforum.com/showthread...hreadid=504300 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to quickly divide a cell by another cell in a different column but same row?
Excel automatically does this for you. In B1, type =A1/2
Copy it down and in B2, you should have =A2/2 ************ Hope it helps! Anne Troy www.OfficeArticles.com "windbreak" wrote in message ... Example: Row -- A ---- B 1 ----- 1 -- =*A1*/2 2 ----- 2 -- =*A2*/2 3 ----- 3 -- =*A3*/2 4 ----- 4 -- =*A4*/2 How can I change the A1, A2, etc to something more general like AX/2 where X is the row that it is in? Thanks, and sorry if this is too basic, I don't know what it is called that I am trying to do. -- windbreak ------------------------------------------------------------------------ windbreak's Profile: http://www.excelforum.com/member.php...o&userid=30763 View this thread: http://www.excelforum.com/showthread...hreadid=504300 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to quickly divide a cell by another cell in a different column but same row?
Oh wow, simple. You're right, it does do that. I didn't know just copying/pasting like that would automatically change the row number. Thanks for your help! -- windbreak ------------------------------------------------------------------------ windbreak's Profile: http://www.excelforum.com/member.php...o&userid=30763 View this thread: http://www.excelforum.com/showthread...hreadid=504300 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to quickly divide a cell by another cell in a different column but same row?
Cool beans. Now, make sure you're copying the "easy" way! See "the fill
handle": http://www.officearticles.com/excel/...soft_excel.htm And if you want some real fun, take my extreme Excel tutorial: http://www.officearticles.com/tutori...soft_excel.htm ************ Hope it helps! Anne Troy www.OfficeArticles.com "windbreak" wrote in message ... Oh wow, simple. You're right, it does do that. I didn't know just copying/pasting like that would automatically change the row number. Thanks for your help! -- windbreak ------------------------------------------------------------------------ windbreak's Profile: http://www.excelforum.com/member.php...o&userid=30763 View this thread: http://www.excelforum.com/showthread...hreadid=504300 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to quickly divide a cell by another cell in a different column but same row?
Great tip. It's definitely very helpful. Thanks again. -- windbreak ------------------------------------------------------------------------ windbreak's Profile: http://www.excelforum.com/member.php...o&userid=30763 View this thread: http://www.excelforum.com/showthread...hreadid=504300 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
| creating a bar graph | Excel Discussion (Misc queries) | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| up to 7 functions? | Excel Worksheet Functions | |||
| how to create a variable column in cell reference | Excel Worksheet Functions | |||
Linear Mode
