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

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

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