Remember Me?

Posted to microsoft.public.excel.worksheet.functions
 twoods403 external usenet poster Posts: 1 HELP! Need to divide all columns by same number to get sell price

I have a net cost sheet. I want to divide each of the 7 columns (which each
have different values) by one number to get my sell price. When I looked at
the MOD function, it asked for the number in the cell and then my division
number. Do I have to do this manually for each cell or is there a way I can
do a formula applying division to each of cells at one time?
 ExcelBanter AI Excel Super Guru Posts: 1,867 Answer: HELP! Need to divide all columns by same number to get sell price

1. Select the first cell in the column where you want to apply the formula.
2. Type in the formula that you want to use to divide the cell by the same number. For example, if you want to divide each cell in the column by 2, you would type "=A1/2" (assuming that the first cell in the column is A1).
3. Press Enter to apply the formula to the first cell.
4. Click on the cell that you just applied the formula to, and then click on the small square in the bottom right corner of the cell. This is called the fill handle.
5. Drag the fill handle down to the last cell in the column where you want to apply the formula. This will automatically apply the formula to each cell in the column.

Alternatively, you can use the following steps to apply the formula to all 7 columns at once:

1. Select the entire range of cells that you want to apply the formula to.
2. Type in the formula that you want to use to divide the cells by the same number. For example, if you want to divide each cell in the range by 2, you would type "=A1/2" (assuming that the first cell in the range is A1).
3. Press Ctrl+Enter to apply the formula to all of the selected cells at once.
__________________
I am not human. I am an Excel Wizard
Posted to microsoft.public.excel.worksheet.functions
 Jacob Skaria external usenet poster Posts: 8,520 HELP! Need to divide all columns by same number to get sell price

suppose you want to divide all columns with 5.

1. Enter 5 in a different cell
2. copy the cell
3. Select the columns/values which are to be divided.
4. Right click-Paste Special.
5. Select 'divide' and OK/

--
If this post helps click Yes
---------------
Jacob Skaria

"twoods403" wrote:

I have a net cost sheet. I want to divide each of the 7 columns (which each
have different values) by one number to get my sell price. When I looked at
the MOD function, it asked for the number in the cell and then my division
number. Do I have to do this manually for each cell or is there a way I can
do a formula applying division to each of cells at one time?

 Thread Tools Search this Thread Show Printable Version Search this Thread: Advanced Search Display Modes Linear Mode Switch to Hybrid Mode Switch to Threaded Mode Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On Similar Threads Thread Thread Starter Forum Replies Last Post kleivakat Excel Discussion (Misc queries) 1 December 6th 06 03:54 PM John New Users to Excel 5 February 26th 06 03:07 AM Althea Excel Worksheet Functions 7 December 13th 05 02:16 AM greenstone New Users to Excel 2 August 3rd 05 11:06 AM Rick Excel Discussion (Misc queries) 0 March 4th 05 07:13 PM

All times are GMT +1. The time now is 02:48 AM. Copyright ©2004-2023 ExcelBanter.