Excel - IF Function Problem - Expert Solution

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

I need a formula that will add or subtract from the amount of 100 but also, show the amount of 100 if you put a 0 in the column
Solved by B. Y. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 06/03/2018 - 03:00
Excelchat Expert 06/03/2018 - 03:00
How are you and how may i assist you with?
Excelchat Expert 06/03/2018 - 03:03
Are you there?
User 06/03/2018 - 03:03
Excelchat Expert 06/03/2018 - 03:03
Thats nice?
Excelchat Expert 06/03/2018 - 03:04
It would have been great if could share me sample of your data
Excelchat Expert 06/03/2018 - 03:05
Okay thats great
Excelchat Expert 06/03/2018 - 03:06
so whats is your requirement on this ?
User 06/03/2018 - 03:07
I would like for the avg column to add or subtract from pts colums but if there is nothing in pts column avg column to show 0 and if there is a 0 in the pts column the avg column shows 100
Excelchat Expert 06/03/2018 - 03:10
Now add any number in pts coulmn
User 06/03/2018 - 03:11
that did not work
Excelchat Expert 06/03/2018 - 03:12
Excelchat Expert 06/03/2018 - 03:12
give me while let me re-evaluate why this is showing like this
Excelchat Expert 06/03/2018 - 03:14
now i guess its working out for you?
Excelchat Expert 06/03/2018 - 03:15
Add up a number
User 06/03/2018 - 03:16
that part work but how do I get it to show 0 in avg column when there is no number in the pts column
Excelchat Expert 06/03/2018 - 03:17
Meas if there is 0 in pts then it should show 0 in Avg column?
User 06/03/2018 - 03:18
no if there is no number in pts it is blank than the avg column should be 0
Excelchat Expert 06/03/2018 - 03:19
okay, will do that for you
User 06/03/2018 - 03:20
so what is the formula I use?

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
The Allstate Corporation
United Parcel Service
Dell Inc