# Excel - IF Function Problem - Expert Solution

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

IF cell R10 contains the formula =\$R1+R\$2, which is then copied to cell S20, what formula is entered in cell S20?
Solved by B. Y. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 07/10/2018 - 02:57
Hi welcome to excelchat
User 07/10/2018 - 02:58
hi
Excelchat Expert 07/10/2018 - 02:59
IF cell R10 contains the formula =\$R1+R\$2 and if it is copied to S20 then you wants to know what formula is present?
Excelchat Expert 07/10/2018 - 02:59
is this is what you are looking for
Excelchat Expert 07/10/2018 - 03:01
Hi There?
Excelchat Expert 07/10/2018 - 03:02
Hi please respond if you are there
Excelchat Expert 07/10/2018 - 03:04
Hi when you copy same and paste it to S20 =\$R11+S\$2 formula will be present
Excelchat Expert 07/10/2018 - 03:05
let me explain how it is in \$R1 column is locked and in R\$2 row number 2 is locked
Excelchat Expert 07/10/2018 - 03:08
as you copy this to cell R10 to S20 \$R1 changes to \$R11 only row value changes as the column is locked, and R\$2 changes to S\$2 as you can see row number remains the same but the column changed to S
Excelchat Expert 07/10/2018 - 03:08
Hi are you there?
Excelchat Expert 07/10/2018 - 03:08
Excelchat Expert 07/10/2018 - 03:09
Do you need any further clarification on the same?
Excelchat Expert 07/10/2018 - 03:09
HI if you are there please respond, and I can clarify if you have any doubts.
Excelchat Expert 07/10/2018 - 03:11
Please feel to extend your session if you still need any clarification.
Excelchat Expert 07/10/2018 - 03:12
Thanks for visiting Excelchat, keep visiting us for any doubts you have! have a great day.
Excelchat Expert 07/10/2018 - 03:12
Thank you

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.