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.
