I don't know what you algorithm for calculating interest is but to see if 4
or more of your share values have incresed try this:-

=IF(COUNT(IF(A1:A5B1:B5,A1:A5,FALSE))=4,"4 or more have increased","Less
than 4 have increased")

You start values are in A1 - A5 and the end values in b1 - B5. Its an array
so enter with Ctrl+Shift+Enter

Mike

"henriques" wrote:

I need a formula that calculates interest to receive if at least 4 of 5
shares are higher at determination date then subscription date. I tried with
=if(and/or, but it is not enough because those logical operators applies to
all shares.