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

Hi

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

yes

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

Okay

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