Need help making Excel formula

Here is an easy macro to do what you want to do.

Open your workbook

Copy this macro to the clipboard

Sub Divide_All_By_E1()

Dim rng As Range

Set rng = Range("B1:B" & Range("B65536").End(xlUp).Row)

For Each cell In rng

cell.Select

ActiveCell.Offset(0, 1).Value = ActiveCell.Value / [E1]

Next

End Sub

Press ALT + F11

Insert > Module

Paste the macro into the module space to the right

Close back to Excel

Go to Tools > Macro > Macros

Highlight this macro, if not already highlighted.

Click Options

Select a letter to use as a keyboard shortcut

Close back to Excel

If your data is in place in column B and cell E1, press Ctrl + your keyboard shortcut letter.

To divide B1 by E1:

In C3, put: =B3/$E$1

To put this formula in column C without retyping it every time:

In the first cell, type your formula. Copy and then paste it. (or, select it and drag the formula down by pulling the bottom right corner). Excel will automatically change the formula from B3/$E$1 to B4/$E$1 to B5/$E$1 and so on.

Or - to replace the contents of B1:B10 with the results of each cell divided by E1:

Copy E1 > Select B1:B10 > Right-click: paste special > Select "Divide".

I think there is a very simple way to do that. If the single number in E1 is constantly used as the divisor, you may not need to put the number in cell E1, instead put it in the formula.

Say 9 is the number in E1, so I would put my pointer in C1 and type +B1/9 and click on it, the result will appear. You don't need to do this in every single cell individually, just copy this cell and paste it to all the C cells you need.

However, if you want to keep the E1, in C1 type +B1/$E$1. Click on it, the result will appear. Copy this cell and paste it to all the C cells you need.

Hope this helps!

(I just found out that both ways are easy enough to do:)

ok, this is VERY easy to do.

First go to your first cell in C1 and type the formula

=B1/$E$1

now just copy/paste this formula all the way down.

Notice the $E$1 in the cell reference? This tells Excel to make it an "absolute" reference and not to change this cell as you copy/paste it.

The $E tells Excel not the change the column reference. The $1 tells it not to change the row reference. So for further education, you could type $E1 and when you copy/paste, excel will keep it locked on column E, but change the rows accordingly. You could do the same with the row reference (ie: lock the row #, but let Excel change the column).

You can also add this "absolute" reference by pressing the <F4> key while you're typing the formula. Pressing it again, will change it to column only, pressing again changes it to row only, pressing again removes it completely.

See...very easy to do :-))))

type your formula in cell c3 (can be =b3/e1 or +b3/e1) and copy c3 to the rest of the cells you need to be filled in (c4, c5 etc...) c4 and the rest will be filled in by b4/e2, c5 by b5/e3 and so on, but you only need the number in e1. Here's how - You have to highlight c4 and the rest down then click on "edit" on the toolbar and click "replace". type e* in the "find what:" space, and type e1 in the "replace with:" space then click "replace all".

You want to make a formula with a spreadsheet program. I would try making the formula first with a formula program (like OpenOffice Math; you can download the OpenOffice suite package free from http://download.openoffice.org/other.html#en-US ) and then copying (Ctrl+C) the completed formula and pasting it into the spreadsheet cells (Ctrl+V) . By the way, for OpenOffice to work, you must have the JRE installed. You can download this (also free) from https://cds.sun.com/is-bin/INTERSHOP.enfinity/WFS/... . (You can right-click the links and click 'open in new window' or 'open in new tab' , this is a good way to get to the download sites without "losing your place" )

Good question! I have tried doing that since the first time I used excel and I don't think you can. I will be really surprised if somebody comes with a working good answer to this.

A1 program name, B1 is start, C1 is finish D1 =IF(B1>C1,(1+C1)-B1,C1-B1) format this cell as [h]:mm Copy D1 down for each program