Forum Discussion
Solved
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 fo...
GerdS55 See attached!
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.
- Just tried that but cell A12 still returns 1
GerdS55 See attached!
- Thank you for your response. I tried several times to do as you showed with no result. I finally closed Excel and restarted my computer and tried it again and now it works perfectly. Any ideas why this would happen?
