# Excel - IF Function Problem - Expert Solution

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

I have a series of number , I want to show if there is a positive number then 0 else add the negative number to the positive number till i get total negative number , basicaly showing what is due
Solved by A. D. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 22/03/2018 - 07:07
Excelchat Expert 22/03/2018 - 07:07
Please share sample data in the preview.
User 22/03/2018 - 07:08
hello
User 22/03/2018 - 07:08
I am stuck here
Excelchat Expert 22/03/2018 - 07:08
Ok. What is the expected output?
User 22/03/2018 - 07:08
I want to show the cumulative -ve number
Excelchat Expert 22/03/2018 - 07:08
Can you please fill all the values.
Excelchat Expert 22/03/2018 - 07:09
User 22/03/2018 - 07:10
if the sum is >0 then 0
User 22/03/2018 - 07:10
till it finds a value <0
User 22/03/2018 - 07:10
the +ve numbers can vary but not more than 5
Excelchat Expert 22/03/2018 - 07:15
IN D19 cell, I am getting a negative value, if i count from top.
Excelchat Expert 22/03/2018 - 07:15
But, you are looking for the count from the previous zero?
User 22/03/2018 - 07:15
not from top
User 22/03/2018 - 07:16
I need if the value in B17 is positive then sum b18
User 22/03/2018 - 07:16
if the b17+b18 is positive thhen b17+b18+b19+ till I get -ve value
Excelchat Expert 22/03/2018 - 07:17
You want to sum it blocks by blocks.
User 22/03/2018 - 07:17
yes
User 22/03/2018 - 07:18
but it should count till it find a -ve value
Excelchat Expert 22/03/2018 - 07:18
It is not possible with formulas, i guess. .as we can't store the values.
Excelchat Expert 22/03/2018 - 07:18
You have to try with vba only to solve this problem.
User 22/03/2018 - 07:18
can you help
Excelchat Expert 22/03/2018 - 07:19
We are not supporting vba. I tried solving it through formulas and realized that, it needs a vba.
User 22/03/2018 - 07:19
where can I get VBA help
Excelchat Expert 22/03/2018 - 07:20
You may have to try another resources at the moment. We will be back with vba support soon. Sorry for the inconvenience.
User 22/03/2018 - 07:20
ok thanks
Excelchat Expert 22/03/2018 - 07:20
You are welcome.
Excelchat Expert 22/03/2018 - 07:20
Please visit Got It Pro for any formula queries or the features that we can support that are listed on the site. Thank you.
Excelchat Expert 22/03/2018 - 07:20
Have a great day.
User 22/03/2018 - 07:21
thank you

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.