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
|