thanks but this formula doesn't work on other numbers -try 30% - it should give you 37 - while it gives 119...the working formula:
A1 = Individual loss (1), B2 = Target cumulative loss (50%)
=CEILING(LOG(1-B1,(100-A1)/100),1)+1
Should a useful addition to the money management toolkit of...