| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculating column based on formula
What happens if Macro!G11 is empty or is equal to 0?
Why use the =sum() function. Why did the column change from J to D? S Himmelrich wrote: Solution: Dim rng As Range Set rng = Range(Cells(1, "D"), Cells(Rows.Count, "D").End(xlUp)) rng.Offset(0, 7).Formula = "=IF(J1="""","""",SUM(J1/MACRO!$G$11))" -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating percentages based on the number of checked boxes in a column | Excel Programming | |||
| Calculating sum based on value in adjacent column | Excel Discussion (Misc queries) | |||
| Calculating totals in a column based on a lookup in another column | Excel Worksheet Functions | |||
| Calculating a field based on what is in another column | Excel Discussion (Misc queries) | |||
| Calculating values to column D with formula based on values column A | Excel Programming | |||
Hybrid Mode
