Show cell value in formula instead of cell reference

[Sufiyan97]

Is it possible to show cell value instead of cell reference in a formula? expected results are in column D

Formula (1).xlsx
	A	B	C	D
1	Compensation			Expected
2	1294.23	-52.2	1346.43	1346.43
3	1219.23	-52.2	1271.43	1271.43
4	1219.23	-52.2	1271.43
5	1301.86	-52.2	1354.06
6	1219.23	-52.2	1271.43
7	1305.67	-52.2	1357.87
8	1219.23	-53.66	1272.89
9	1212.16	-53.66	1265.82
10	1240.76	-53.66	1294.42
11	1223.5	-53.66	1277.16
12	1219.23	-53.66	1272.89
13	1219.23	-53.66	1272.89
14	1232.43	-53.66	1286.09
15	1219.23	-53.66	1272.89
16	1231.73	-53.66	1285.39
17	973.99	-53.66	1027.65
18	1099.87	-53.66	1153.53
19	1268.63	-53.66	1322.29
20	1033.58	-53.66	1087.24
21	22953.02	903.46	22049.56
22
Sheet2

Cell Formulas
Range	Formula
D2	D2	=1294.23+52.2
D3	D3	=1219.23+52.2
C2:C21	C2	=A2-B2

this might help by Fluff

Convert Part of Formula as values

Is there any way to convert B2 formula as =6977835.66/1000 and so on ABC1OriginalDivide By 1000Expected...

www.mrexcel.com

 

[DanteAmor]

Thank you very much Dante, That is it.

Thank you for your time and help.

If the option with macro is accepted, then here is a shorter version.
Similarly change "D" by the letter of the column where you want the result.

Sub ExpectedResult_1()
  Dim c As Range, s As String
  For Each c In Range("A2", Range("A" & Rows.Count).End(3))
    If c.Offset(, 1).Value < 0 Then s = "+" & -c.Offset(, 1).Value Else s = "-" & c.Offset(, 1).Value
    Range("D" & c.Row).Formula = "=" & c.value & s
  Next
End Sub

or:

Sub ExpectedResult_3()
  Dim c As Range, s As String
  For Each c In Range("A2", Range("A" & Rows.Count).End(3))
    Range("D" & c.Row).Formula = "=" & c.Value & IIf(c.Offset(, 1).Value < 0, "+" & -c.Offset(, 1).Value, "-" & c.Offset(, 1).Value)
  Next
End Sub

 

[Sufiyan97]

Thanks Dante for shorter versions.

 

[DanteAmor]

Im glad to help you. Thanks for the feedback.