Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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?
  #2   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up 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
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,520
Default 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?

Reply
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
Pivot table - total sell price kleivakat Excel Discussion (Misc queries) 1 December 6th 06 03:54 PM
Calculate the percentage from the cost and recommended sell price John New Users to Excel 5 February 26th 06 03:07 AM
Divide date into separate columns Althea Excel Worksheet Functions 7 December 13th 05 02:16 AM
can you count the number of letters (inc spaces) in a single sell greenstone New Users to Excel 2 August 3rd 05 11:06 AM
Divide one row over other row I dont wont to divide one number Rick Excel Discussion (Misc queries) 0 March 4th 05 07:13 PM


All times are GMT +1. The time now is 02:48 AM.

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

About Us

"It's about Microsoft Excel"