| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Looking for a formula that will divide a column & rows by 2
I would like to have a formula for a column in my worksheet that can divide
a number by 2. Example: Total Value Total Sale $3.00 $1.50 $4.00 $2.00 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Looking for a formula that will divide a column & rows by 2
Say $3.00 in A2 just enter this in B2. =A2/2 if you want to hide zero's then enter =IF(A1="","",A1/2) VBA Noob -- VBA Noob ------------------------------------------------------------------------ VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833 View this thread: http://www.excelforum.com/showthread...hreadid=570984 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Looking for a formula that will divide a column & rows by 2
Assuming columns A and B
In Total Sales B2 enter =A2/2 If you don't yet have a value in column A enter the formula as =IF(A2="","",A2/2) so B2 will look blank if no value in A2 Drag/copy down column B as far as you wish. Gord Dibben MS Excel MVP On Fri, 11 Aug 2006 23:19:01 -0700, anchar wrote: I would like to have a formula for a column in my worksheet that can divide a number by 2. Example: Total Value Total Sale $3.00 $1.50 $4.00 $2.00 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| repeat a formula same column same number of rows apart | Excel Discussion (Misc queries) | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| creating a bar graph | Excel Discussion (Misc queries) | |||
| Same formula in each cell of column; insert rows w/o copying down | Excel Discussion (Misc queries) | |||
| Formula to compare multiple rows values based on another column? | Excel Worksheet Functions | |||
Linear Mode
