Question description:
This user has given permission to use the problem statement for this
blog.
Hey so I need to update column S rows S2:S8298, based on a conditional in values found in column M rows M2:M8298. If the value in M is 1, I need to add .25 to the corresponding S value, If m=2 i need to add 2.75, if m=3 i need to add 27.5, if m=4 i need to add 275, m=5 i need to add 2,750, if m=6 i need to add 27,500 and if m=7 i need to add 275,000
Solved by X. W. in 12 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
03/07/2018 - 04:25
Hi
Excelchat Expert
03/07/2018 - 04:25
Welcome to Got It Pro
Excelchat Expert
03/07/2018 - 04:25
Please share the sample info in the preview.
User
03/07/2018 - 04:26
you want me to copy my info from my question?
Excelchat Expert
03/07/2018 - 04:26
No. Please paste sample info in preview.
Excelchat Expert
03/07/2018 - 04:26
So, i can write formula for all the conditions.
User
03/07/2018 - 04:27
im unable to preview the info, is my question not sufficient information to make a formula? I'd be happy to give more info but i cannot preview
Excelchat Expert
03/07/2018 - 04:27
Please refresh browser. You are not able to see it.
Excelchat Expert
03/07/2018 - 04:28
I am writing formula based on the conditions of M column.
User
03/07/2018 - 04:29
thank you. i can see the preview option but I am not able to preview the actual information for other reasons. if you could simply give me a formula for those conditions in the m column that would be very much appreciated!
Excelchat Expert
03/07/2018 - 04:29
Ok. I am working on it.
User
03/07/2018 - 04:30
thanks, let me know if you need clarificatoin
User
03/07/2018 - 04:30
*clarification
Excelchat Expert
03/07/2018 - 04:32
=if(M2=1,0.25,if(M2=2,2.75,if(M2=3,27.5,if(M2=4,275,if(M2=5,2750,if(M2=6,27500,if(M2=7,275000,0)))))))
Excelchat Expert
03/07/2018 - 04:32
Please add the formula after equal to.
Excelchat Expert
03/07/2018 - 04:33
Whether there is a formula in column S already? or they are entered manually
Excelchat Expert
03/07/2018 - 04:33
?
User
03/07/2018 - 04:33
will try right now
Excelchat Expert
03/07/2018 - 04:33
Sure.
Excelchat Expert
03/07/2018 - 04:33
It is nested if function.
User
03/07/2018 - 04:34
i believe I am incorrectly selecting all of column s to be updated
Excelchat Expert
03/07/2018 - 04:34
it is just for S2 cell.
Excelchat Expert
03/07/2018 - 04:34
S2 contain formula? or value?
User
03/07/2018 - 04:35
s2 through s8298 are simply values
Excelchat Expert
03/07/2018 - 04:35
Ok. Then you have to add this to new column.
User
03/07/2018 - 04:35
will try
Excelchat Expert
03/07/2018 - 04:35
You can just add it to S2 cell.
Excelchat Expert
03/07/2018 - 04:35
In the new column. Please add it like this.
Excelchat Expert
03/07/2018 - 04:35
=S2+if(M2=1,0.25,if(M2=2,2.75,if(M2=3,27.5,if(M2=4,275,if(M2=5,2750,if(M2=6,27500,if(M2=7,275000,0)))))))
Excelchat Expert
03/07/2018 - 04:36
That is for second row only.
User
03/07/2018 - 04:36
it worked for that, how can i do it for all?
Excelchat Expert
03/07/2018 - 04:36
Once it is entered, please copy the formula downwards.
Excelchat Expert
03/07/2018 - 04:36
Select the cell
User
03/07/2018 - 04:36
okay, if that is only way to do it thank you very much
Excelchat Expert
03/07/2018 - 04:36
copy it and paste it for others.
Excelchat Expert
03/07/2018 - 04:36
Thank you.
Excelchat Expert
03/07/2018 - 04:36
Please do visit Got It Pro. We have 24 * 7 problem solving facility. You can visit any time.
Excelchat Expert
03/07/2018 - 04:37
Have wonderful day ahead. Please end the session and leave valuable feedback.
User
03/07/2018 - 04:37
Excellent service, especially because i couldnt use the preview function!
User
03/07/2018 - 04:37
wish i could compliment you to your supervisor
Excelchat Expert
03/07/2018 - 04:37
Thank you.Please write it after ending the session.
User
03/07/2018 - 04:37
will do! have a great day
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.