Question description:
This user has given permission to use the problem statement for this
blog.
i want to insert a multiplication formula in a cell if some percentage value is entered in another cell of same row. for eg. if i put a formula in G7 cell (=G2*e7) but it should be enabled or activated if i put some data entry in f7 cell Excel
Solved by Z. D. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
12/10/2018 - 08:53
Hi, Welcome to excelchat
Excelchat Expert
12/10/2018 - 08:53
Before we get started, this is a reminder that our policy is 1 problem per session with additional Q&A on that problem as time allows
User
12/10/2018 - 08:53
hi
Excelchat Expert
12/10/2018 - 08:53
Let me ask you a couple of quick questions to make sure I fully understand your problem.
User
12/10/2018 - 08:53
ok
Excelchat Expert
12/10/2018 - 08:53
Could you please the problem in detail
Excelchat Expert
12/10/2018 - 08:54
What should be the formula in G7?
User
12/10/2018 - 08:54
=g2*e7
Excelchat Expert
12/10/2018 - 08:56
I have the formula in cell G7: =IF(ISBLANK(F7),,G2*E7)
Excelchat Expert
12/10/2018 - 08:56
Which will be calculated, only if F7 is not empty
Excelchat Expert
12/10/2018 - 08:57
So, if you look at the preview sheet, I have highlighted cells which I have modified
Excelchat Expert
12/10/2018 - 08:57
Please have a look and let me know if this solves your problem
Excelchat Expert
12/10/2018 - 09:00
Are you there
User
12/10/2018 - 09:00
YES THANKS FOR THE SUPPORT, MY ISSUE WAS RESOLVED NOW
Excelchat Expert
12/10/2018 - 09:00
here is the file also
[Uploaded an Excel file]
Excelchat Expert
12/10/2018 - 09:01
Do you have any other questions about this problem and the solution?
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.
