How to appending a cell reference to column

[MuhammadTawfiq]

I need to multiply a value to all cells in a column, but in the same time still shown as in the attached image

 

[Peter_SSs]

Is this what you mean?

24 08 18.xlsm
	A	B	C
1	1.05
2
3
4	1400		1470
5	1780		1869
6	2350		2467.5
7	2900		3045
Multiply all

Cell Formulas
Range	Formula
C4:C7	C4	=A4:A7*A1
Dynamic array formulas.

 

[MuhammadTawfiq]

Thanks for reply,
But I need the cell (C4) =1400*$A1$ not =A4:A7*A1

 

[Peter_SSs]

But I need the cell (C4) =1400*$A1$ not =A4:A7*A1

1400*$A$1=1470 which is what my formula gives in C4.
What number do you think should appear in C4?

 

[MuhammadTawfiq]

Sorry Bro.
You know, I go to every cell in column C and do the following steps manually:
For C4 which has value 1400
1. adding "=" in the beginning
2. adding in the end "*$A$1"
To get a cell with this value "=1400*$A$1" , till anyone can check the cell value (1400 original price) and ($A1$ percentage)
And so on for all column C ,
Can you show me another method to do it easier?
To appear in C4 "=1400*$A$1" and C5 "=1780*$A$1"

 

[Peter_SSs]

Sorry, I can't see why you are more interested in the formula than the results that the formula gives.
Why do you want =1400*$A$1 instead of =A4*$A$1?

 

[MuhammadTawfiq]

Now you got it, I'm totally in your side, but this is old school someone still there.

 

[Peter_SSs]

Now you got it, I'm totally in your side, but this is old school someone still there.

Hmm, I'm not sure whether you have what you want or not. Reading your messages again, I'm wondering if you want a macro like this?

Sub Make_Formulas()
  Dim c As Range
  
  For Each c In Range("A4:A7")
    c.Offset(, 2).Formula = "=" & c.Value & "*$A$1"
  Next c
End Sub

Starting with only column A below, the macro makes the formulas shown in column C.

MuhammadTawfiq.xlsm
	A	B	C
1	1.05
2
3
4	1400		1470
5	1780		1869
6	2350		2467.5
7	2900		3045
Sheet1

Cell Formulas
Range	Formula
C4	C4	=1400*$A$1
C5	C5	=1780*$A$1
C6	C6	=2350*$A$1
C7	C7	=2900*$A$1

 

[MuhammadTawfiq]

WOW, that exactly I need,
Many thanks Bro

 

[Peter_SSs]

You're welcome. Glad we got there in the end.
Thanks for the confirmation.