**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.*