Forum Discussion
GerdS55
Oct 05, 2023Copper Contributor
Formula not working in my spreadsheet
Hi. I have a spreadsheet which I use to follow different stocks. I am having problems with one of my formulas. It gives me incorrect results, which messes up my list of stocks that I am looking for. I have attached a part of the spreadsheet which contains the non-working formula. Any thoughts on how to fix this. The cell in question is A12. It is an indicator which identifies stocks for me. Cell A11 is showing blank, as it should, but Cell A12 seems to think otherwise. Thank you for looking.
GerdS55 See attached!
- Riny_van_EekelenPlatinum Contributor
GerdS55 Not sure I understand your schedule but the fact that A11 return "" is the source of your problem, I believe.
Change the formula to
=IF(AND(SUM(A8:A10)>0,A7=1,OR(A9>0,A10>0)),SUM(A8:A10),0)
Then A12 will be blank.
- GerdS55Copper ContributorJust tried that but cell A12 still returns 1
- Riny_van_EekelenPlatinum Contributor