Hi again guys,
Thanks for beeing so helpful.
Now I have another problem. This IF formula here is counting blank cells as zero (since the percentile of the data in the if formula is a negative value blanks=zero which is above the negative value and is therefore returned).
=(IF('Monthly Performance'!B21>=PERCENTILE('Monthly Performance'!$B$21:$AN$21,0.7),(((1+'Monthly Performance'!B21))^(1)-1),""))
Anyone got a solution to this? I would be very grateful!
Please see attached.
/Frans
Bookmarks