Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
If data exists in column J, put formula in column K
the formula is basically:
=SUM(J1/MACRO!G11) J1, must change as formula moves down each row, "MACRO!G11" stays the same |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
If data exists in column J, put formula in column K
Are you looking for this?
=SUM(J1/MACRO!$G$11) Rick "S Himmelrich" wrote in message ... the formula is basically: =SUM(J1/MACRO!G11) J1, must change as formula moves down each row, "MACRO!G11" stays the same |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
If data exists in column J, put formula in column K
S Himmelrich,
What about wrapping an IF() function around your formula? Enter this formula in K1 =IF(J1="","",SUM(J1/MACRO!$G$11)) HTH, Conan Kelly "S Himmelrich" wrote in message ... the formula is basically: =SUM(J1/MACRO!G11) J1, must change as formula moves down each row, "MACRO!G11" stays the same |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
If data exists in column J, put formula in column K
Check your earlier post.
S Himmelrich wrote: the formula is basically: =SUM(J1/MACRO!G11) J1, must change as formula moves down each row, "MACRO!G11" stays the same -- Dave Peterson |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
If data exists in column J, put formula in column K
I've re-posted my original request to be more specific - sorry for the
lack of explaination in my original posting. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
If data exists in column J, put formula in column K
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))" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count data in one column if certain criteria exists in another. | Excel Worksheet Functions | |||
Based on a condition in one column, search for a year in another column, and display data from another column in the same row look | Excel Programming | |||
Copying a formula in a blank column as far as data in previous column | Excel Programming | |||
Determine if Value in column A exists in Column B | Excel Discussion (Misc queries) | |||
Find if value in column A exists in Column B | Excel Worksheet Functions |