Question description:
This user has given permission to use the problem statement for this
blog.
I need a formula to add E2 with H2 and I2 only if the value in E2 is greater than 20
Solved by E. L. in 6 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
22/04/2018 - 05:02
Hi…Welcome to Got It Pro
User
22/04/2018 - 05:02
hey
Excelchat Expert
22/04/2018 - 05:03
Let us do a demo in this blank sheet.
User
22/04/2018 - 05:03
ok
Excelchat Expert
22/04/2018 - 05:04
Will the data that I just put be ok for this demo?
User
22/04/2018 - 05:04
sure
Excelchat Expert
22/04/2018 - 05:04
Which cell do you want the formula in?
User
22/04/2018 - 05:04
formula should be in E2
Excelchat Expert
22/04/2018 - 05:05
Your query was - o add E2 with H2 and I2 only if the value in E2 is greater than 20
User
22/04/2018 - 05:05
yes
Excelchat Expert
22/04/2018 - 05:05
You can have the formula in E2, if you are also adding E2 in to the formula
Excelchat Expert
22/04/2018 - 05:05
also your criteria is in E2
User
22/04/2018 - 05:06
Sorry the result should be in F2
Excelchat Expert
22/04/2018 - 05:06
sorry, I meant you cannot have the formula in E2
Excelchat Expert
22/04/2018 - 05:06
ok got you
Excelchat Expert
22/04/2018 - 05:07
please see the formula in F2
Excelchat Expert
22/04/2018 - 05:07
you can test it by changing the value in E2
Excelchat Expert
22/04/2018 - 05:07
Does that solve your query?
User
22/04/2018 - 05:08
yes
Excelchat Expert
22/04/2018 - 05:08
perfect
Excelchat Expert
22/04/2018 - 05:08
Is there anything else I can help you with this query?
User
22/04/2018 - 05:08
Not today thank you
Excelchat Expert
22/04/2018 - 05:08
Please do give me a good feedback for my service.
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.
