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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks