Insert a value to a cell in excel using formula in another cell

0
votes

I need to insert a value to a cell in excel using formula in another cell.

Say 

A1 = "Test"
B1 = formula to insert A1 to C1
C1 = A1

Can I write a formula in B1 to insert value in C1? I don't need any formulas in C1. If Yes, What should be the formula?

2
excelexcel-formula
you can achieve this with VBA but I am not sure about the same with just formaulas – Sivaprasath Vadivel
I don't understand the question. A1 is 'test' and C1 is =A1, but B1? And what do you want with the formula of B1? Please provide a sample input and desired output. – Sangbok Lee
You cannot change the value of another cell using a native worksheet function or formula and you are not supposed to be able to do this in VBA either. The reasoning is valid; cyclic calculation that produces circular references that are too complex to be reasonably determined. – user4039065
Is B1 supposed to be just a logical test returning TRUE or FALSE whether to make C1 = A1? In that case, it seems like a simple IF statement in C would work. =IF(B1=TRUE,A1,"") – Jacob Edmond

2 Answers

1
votes

If there it is next to the cell AND has no value in B2, it is possible, otherwise it is not.

Use Split()

Split(CONCATENATE("USELESS STUFF HERE#Sperator$$",A1),"#Sperator$$",FALSE)

It really depends.

0
votes

Without using VBA or formulas in column C you can't achieve this.

A simple solution using formulas:

In cell C1, paste the following formula and drag it down:

=IF(B1=1;A1;"")

enter image description here

So if the content of cell B1 is equal to 1, your cell at column C will display the respective value of the same row at column A.