# Excel - IF Function Problem - Expert Solution

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

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.