Looking for a formula that will divide a column & rows by 2

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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 Noo
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cumulative time calculation in Excel 2003 2
Sorting and maintaining formula integrity 5
Counting the items 4
With F1 value, look at A, if match or partial match return B 5
price list changes using conditional functions? 3
multiple results display after filter function 1
Changing formula totals 2
Cashier Balance Sheet 2

Back
Top