Excel - IF Function Problem - Expert Solution

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

I rate shoddy work mercilessly. I require an expert to handle my complex finance data for very critical and analytical skills and data in excel. dont risk if you are an average expert
Solved by M. J. in 13 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 24/05/2018 - 04:52
Hello, how are you?
User 24/05/2018 - 04:52
Am good thanks, yourself?
Excelchat Expert 24/05/2018 - 04:53
Am good too. How may I be of assistance to you?
User 24/05/2018 - 04:54
I require some advice on how to present my finance data in a simple way
Excelchat Expert 24/05/2018 - 04:55
Do you mind uploading the excel file so that I can examine it locally?
User 24/05/2018 - 04:56
Am afraid it contains very sensitive data so i cannot share
User 24/05/2018 - 04:56
Are you not able to explain?
Excelchat Expert 24/05/2018 - 04:56
I can and i will
Excelchat Expert 24/05/2018 - 04:57
Now, you need to use a pivot table
User 24/05/2018 - 04:57
How do i go about that?
Excelchat Expert 24/05/2018 - 04:58
You need to select the whole of your data you want to analyse then click insert
User 24/05/2018 - 04:58
Hold on please
Excelchat Expert 24/05/2018 - 04:58
Am waiting
Excelchat Expert 24/05/2018 - 04:58
Are you there?
User 24/05/2018 - 04:58
Yes
Excelchat Expert 24/05/2018 - 04:59
Then choose pivot table
User 24/05/2018 - 04:59
ok
Excelchat Expert 24/05/2018 - 04:59
then choose to present the table on a new worksheet
Excelchat Expert 24/05/2018 - 05:00
are you able to do that?
User 24/05/2018 - 05:00
yes
Excelchat Expert 24/05/2018 - 05:00
click ok
Excelchat Expert 24/05/2018 - 05:02
It will take you to a new sheet where yo will need to click on the blank table on your left so that it populates field options on your right
Excelchat Expert 24/05/2018 - 05:02
are you there?
User 24/05/2018 - 05:03
Yes i got it, then i have all the options in this field list
User 24/05/2018 - 05:03
Now i can choose them as i want
Excelchat Expert 24/05/2018 - 05:03
Exactly
User 24/05/2018 - 05:04
Oh thankyou so much
User 24/05/2018 - 05:04
am so grateful
Excelchat Expert 24/05/2018 - 05:04
You are so welcome. Please remember to rate me well after closing the session. A 5star will be kind enough. And a nice comment if you don’t mind.
User 24/05/2018 - 05:04
Sure, i will
Excelchat Expert 24/05/2018 - 05:05
Have a good day
User 24/05/2018 - 05:05
Good day too

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.