How to assign a value to a cell using a formula

Question

How to assign a value to a cell using a formula?

Answer 1

Hi Ron_111!

To assign a value to a cell using a formula in Excel on PC, you can follow these steps: * Open a new or existing Excel workbook on your PC. * Click on the cell where you want to assign the value using a formula. * In the formula bar, which is located above the worksheet, type the formula that will generate the desired value. For example, to assign the value of 10 to the cell, you could type "=5+5" (without quotation marks) and press Enter key on your keyboard to execute the formula and assign the resulting value to the selected cell.

Alternatively, you can also use the formula wizard in Excel to assign a value to a cell. Here are the steps to do so: * Click on the cell where you want to assign the value. * In the formula bar, type the equals sign (=) followed by the name of the function or operation you want to perform. For example, to assign the sum of two cells (A1 and B1) to the selected cell, you could type "=SUM(A1:B1)". * Press Enter to execute the formula and assign the resulting value to the selected cell.

See the 2 images below:

Please, remember to give back to the community. Help the next person with this problem by rating and indicating if this conversation was helpful. Thank you

Kind Regards, Shakiru

Answer 2

Thanks but my problem is basic.

Open new workbook.

I want a formula in cell A2 that will put "test" in cell A5.

If I put in cell A2 -> =A5="test"

It just results in False.

cell("contents",A5) just gives me the value in A5

I want to put a value into a cell without using the keyboard.

Answer 3

Hi Ron_111!

To put the value "test" into cell A5 using a formula in cell A2, you can use the following formula:

=IF(A5<>"test","test","")

This formula uses the IF function to check whether the value in cell A5 is already "test". If it is, the formula returns an empty string (""). If it is not, the formula returns the value "test", which will be entered into cell A5.

If you want to keep the existing value in cell A5 and only enter "test" if it is not already there, you can modify the formula as follows:

=IF(A5<>"test","test",A5)

This formula returns "test" if A5 is not already "test", otherwise it returns the existing value in A5. This way, the formula only updates A5 if necessary.

Kind Regards, Shakiru