All solutions IF Expert Solution – Excel IF Problems

Excel - IF Function Problem - Expert Solution

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.

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.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc