# Excel - IF Function Problem - Expert Solution

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

Hi, I need some help in assessing with a formula in excel the earning potential a customer might get if they bought all the top 10 performing products from the product portfolio? This is to show to customers what they might earn if they buy the best selling products. Thanks for your help
Solved by X. H. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 28/06/2018 - 05:20
Hello, I understand that you would like to see the earning potential when buying the top 10 products of your data, right?
User 28/06/2018 - 05:20
correct
Excelchat Expert 28/06/2018 - 05:20
Alright, I can help you with this. Before we proceed, this is a reminder that our policy is 1 question per session so for this session we'll be resolving this particular question. We also currently do not support VBA/Macro solutions.
Excelchat Expert 28/06/2018 - 05:20
Are you able to share your file so I can analyze it?
User 28/06/2018 - 05:21
not at the moment. I don't have it in this device
User 28/06/2018 - 05:21
is it possible to obtain a formula
User 28/06/2018 - 05:21
?
Excelchat Expert 28/06/2018 - 05:22
It is but it highly depends on how your data is formatted. What fields are available, what data types among many other things.
Excelchat Expert 28/06/2018 - 05:22
If you could provide an accurate sample using the document to the right then I'll be able to analyze it and figure out the best way to solve it.
User 28/06/2018 - 05:22
I see, I can explain how it is distributed if that helps
User 28/06/2018 - 05:23
sure , let me input some data in there
Excelchat Expert 28/06/2018 - 05:24
Are you still with me?
User 28/06/2018 - 05:25
yes
Excelchat Expert 28/06/2018 - 05:25
I don't mean to rush you but we have a very limited amount of time to solve this so if we want to have a formula for this before the timer expires, we have to act soon.
Excelchat Expert 28/06/2018 - 05:26
I can see that you are typing a sample data, please go on.
User 28/06/2018 - 05:28
THI IS MORE OR LESS HOW THE DATA IS SET UP
Excelchat Expert 28/06/2018 - 05:28
I see empty cells at the bottom of column B and C, is that intentional?
User 28/06/2018 - 05:28
no
User 28/06/2018 - 05:28
Excelchat Expert 28/06/2018 - 05:28
I'm going to delete the stores without any data.
Excelchat Expert 28/06/2018 - 05:29
Okay, first question. How do you know which are the top 10?
User 28/06/2018 - 05:29
well, some stores do not buy all materials
User 28/06/2018 - 05:29
so some empty cells might happen
User 28/06/2018 - 05:29
for value
Excelchat Expert 28/06/2018 - 05:30
Okay. How do you know which are the top 10 stores?
User 28/06/2018 - 05:30
based on the value, i take the highest value
Excelchat Expert 28/06/2018 - 05:30
Will stores be listed multiple times?
User 28/06/2018 - 05:30
yes
Excelchat Expert 28/06/2018 - 05:31
Okay, next question, how do you determine the earning potential?
User 28/06/2018 - 05:32
that's exactly what I want o know,.. I want to asses the top 10 products, and see which store is not buying all the top 10 .. so let's say they 7 out of the 10, so how much can they earn with the 3 products they do not buy
Excelchat Expert 28/06/2018 - 05:33
I'm sorry I'm a bit lost.
Excelchat Expert 28/06/2018 - 05:33
"which store is not buying all the top 10"
Excelchat Expert 28/06/2018 - 05:33
I thought it's the stores that you are getting the top 10.
Excelchat Expert 28/06/2018 - 05:34
I also need to know how you calculate earning potential so I can transform it to a valid Excel formula.
User 28/06/2018 - 05:34
no, it;s from the ones that do not buy all the 10 products that are porforming well
Excelchat Expert 28/06/2018 - 05:34
You are the only one who can provide that since you are the one who knows how this business works.
Excelchat Expert 28/06/2018 - 05:35
Can you give me an example of the output you expect?
Excelchat Expert 28/06/2018 - 05:35
If you can provide an example of the output then I can transform it to a valid Excel formula that automatically calculates it.
User 28/06/2018 - 05:36
well, it's quite long to explain and i don't have the file with me.. I see only 4 minutes remain so wouldn't have time for all that explanation
User 28/06/2018 - 05:36
Excelchat Expert 28/06/2018 - 05:36
The time can be extended if you are willing.
Excelchat Expert 28/06/2018 - 05:36
But if not, I'd suggest that you post your question to us again once you have the actual file and an explanation prepared.
Excelchat Expert 28/06/2018 - 05:37
For the meantime, I'll be marking this session as done and noting that we weren't able to come up with a solution because you are not able to fully explain what you need and you don't have the file with you.
Excelchat Expert 28/06/2018 - 05:37
If you could provide an explanation then I'll be able to generate a formula for you, but without an explanation, I can't even begin. I hope you understand.
Excelchat Expert 28/06/2018 - 05:39
We have less than a minute remaining and you were not able to extend the session. Since you can't provide an explanation as to what you can do, we can't expect a solution to be given.
Excelchat Expert 28/06/2018 - 05:39
Since you can't provide an explanation as to what you need, we can't expect a solution to be given.*

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.