LinkBack URL
About LinkBacks
How can I change this formula to work only for positive numbers?
=(SUMPRODUCT($N$5:N11,$L$5:L11)/SUMPRODUCT($M$5:M11,$L$5:L11))-1
My goal is to calculate the percentual change of positive numbers only.
How can I change this formula to work only for positive numbers?
=(SUMPRODUCT($N$5:N11,$L$5:L11)/SUMPRODUCT($M$5:M11,$L$5:L11))-1
My goal is to calculate the percentual change of positive numbers only.
Hi bright and welcome to the forum,
Perhaps:
If(((SUMPRODUCT($N$5:N11,$L$5:L11)/SUMPRODUCT($M$5:M11,$L$5:L11))-1) > 0, ((SUMPRODUCT($N$5:N11,$L$5:L11)/SUMPRODUCT($M$5:M11,$L$5:L11))-1), "")
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Thank you, unfortunately, it does not work. Perhaps I wasn't clear hehe.
I will share the spreadsheet so you can understand my goal.
I want to calculate "the positive gainers of my portfolio" therefore, the stocks that the returns are positive, while not counting the stocks with negative returns.
Guess
Cell E19 formula
Formula:
Please Login or Register to view this content.
That worked just fine!! thank you!
Problems are always easier when an attachment with desired results is provided.
Good Job wk9128 for getting it right!!!
@bright01 You're Welcome. Glad to help . Thank You for the feedback
also thank you @MarvinP's and rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks