Excel - IF Function Problem - Expert Solution

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

I need a function in my excel. If a value is entered in cellA5 , that value moves to cell B5 and clears cellA5, and B5value moves to c5
Solved by B. S. in 21 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
User 14/07/2018 - 01:38
Manufacturing
Excelchat Expert 14/07/2018 - 01:39
Hello
Excelchat Expert 14/07/2018 - 01:39
Welcome to excelchat
User 14/07/2018 - 01:39
Ya. Gud eve
Excelchat Expert 14/07/2018 - 01:39
Good evening.
Excelchat Expert 14/07/2018 - 01:40
So, I presume. the problem description is correct, right?
User 14/07/2018 - 01:40
S.
Excelchat Expert 14/07/2018 - 01:41
My apologies, I didn't quite noticed the part where you said "If a value is entered in cellA5 , that value moves to cell B5"
Excelchat Expert 14/07/2018 - 01:42
And clears A5.
Excelchat Expert 14/07/2018 - 01:42
It is not possible to do such things with excel formula.
User 14/07/2018 - 01:43
Pls
User 14/07/2018 - 01:43
Are you clear with my points.
Excelchat Expert 14/07/2018 - 01:43
Yeah, I'm clear.
Excelchat Expert 14/07/2018 - 01:44
Data inputted in cell A5 should be cleared and moved to B5, and the previous value of B5 should be moved to C5.
Excelchat Expert 14/07/2018 - 01:44
Isn't it the requirement?
User 14/07/2018 - 01:45
Yes
Excelchat Expert 14/07/2018 - 01:46
Unfortunately it is not possible to do with formula.
User 14/07/2018 - 01:47
Value in A5 moves to B5 and B5 value moves to C5. No need t o clear A5 cell
Excelchat Expert 14/07/2018 - 01:47
Let's say I input a value in A5, please look at the previous window.
Excelchat Expert 14/07/2018 - 01:48
Now with formula, it is possible to show what is in A5 also in B5, and what is in B5 also in C5.
Excelchat Expert 14/07/2018 - 01:49
Then the values of all three cells would be the same.
Excelchat Expert 14/07/2018 - 01:49
If that is what you need.
Excelchat Expert 14/07/2018 - 01:51
The respective formulas for B5 should be =A5 and formula for C5 should be =B5
User 14/07/2018 - 01:52
So you failed right
User 14/07/2018 - 01:53
Ok
User 14/07/2018 - 01:53
Bye
Excelchat Expert 14/07/2018 - 01:54
My apologies that there isn't a solution to your problem.
Excelchat Expert 14/07/2018 - 01:54
Have a great day ahead!

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.