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
I made a mistake, sorry
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
Thank you for your help
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.