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