# Excel - IF Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

I need a formula to replace one value of a cell with another value of another cell making the two cell values equal. I need to write this as part of the [value_if_true] part in the IF formula.
Solved by O. J. in 36 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 05/07/2018 - 11:58
Hello
User 05/07/2018 - 11:58
hi
Excelchat Expert 05/07/2018 - 11:59
Could you describe me your problem again?
User 06/07/2018 - 12:01
I need a formula to place the value of one cell into another cell making both the cell values the same. This is done in the IF formula in the, [value_if_true] part.
Excelchat Expert 06/07/2018 - 12:04
So, lets see if I understood.. For example, in cell A1 there is number 15. You want that if some logical test is true for example A1 have value 15 also
Excelchat Expert 06/07/2018 - 12:07
Cell A2 was supposed to be in last sentence, sorry
Excelchat Expert 06/07/2018 - 12:09
If I understood you right, that formula would be if(logical test;A2=A1;something what happens if false)
Excelchat Expert 06/07/2018 - 12:09
Are you still there?
User 06/07/2018 - 12:11
yes
User 06/07/2018 - 12:11
using the IF function
User 06/07/2018 - 12:12
I need to calculate
User 06/07/2018 - 12:12
this
User 06/07/2018 - 12:12
my current formula which does not work is this
User 06/07/2018 - 12:12
=IF(SQRT(B4)<E3,=B2,=A2)
Excelchat Expert 06/07/2018 - 12:13
Did you put ; or , in formula
User 06/07/2018 - 12:13
No
Excelchat Expert 06/07/2018 - 12:14
You cannot have kommas between logical test, value if true and value if false
Excelchat Expert 06/07/2018 - 12:14
You have to put ;
User 06/07/2018 - 12:15
The formula still did not work
Excelchat Expert 06/07/2018 - 12:16
Try to write not only =B2 and =A2
Excelchat Expert 06/07/2018 - 12:16
Write name of the cell in front of =
Excelchat Expert 06/07/2018 - 12:16
For example A6=B2;A6=A2
User 06/07/2018 - 12:17
But I want the value of B2 in the cell which I am writing the formula in.
Excelchat Expert 06/07/2018 - 12:18
Okay lets start over
Excelchat Expert 06/07/2018 - 12:19
If sqrt(B4)<E3 what do you want to happen
Excelchat Expert 06/07/2018 - 12:19
Tell me without formulas
Excelchat Expert 06/07/2018 - 12:19
Only words
User 06/07/2018 - 12:21
I want B2 to have the same value as A5. so A5 is 550
Excelchat Expert 06/07/2018 - 12:21
And if that logical test is false what do you want to happen
User 06/07/2018 - 12:24
I want the value of A5 to be 222
Excelchat Expert 06/07/2018 - 12:25
Then your formula would be if(sqrt(B4)<E3;A5=B2;A5=A4)
Excelchat Expert 06/07/2018 - 12:25
Try is this working
User 06/07/2018 - 12:25
ok I will try
Excelchat Expert 06/07/2018 - 12:27
Excelchat Expert 06/07/2018 - 12:27
I found good formula
User 06/07/2018 - 12:28
ok
User 06/07/2018 - 12:28
What is this good formula?
Excelchat Expert 06/07/2018 - 12:31
I wrote it
User 06/07/2018 - 12:31
I will try it
Excelchat Expert 06/07/2018 - 12:31
Okay
User 06/07/2018 - 12:34
yes
User 06/07/2018 - 12:34
User 06/07/2018 - 12:34
It worked
Excelchat Expert 06/07/2018 - 12:34
Great
Excelchat Expert 06/07/2018 - 12:34
Welcome

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.