This is my formula.
How can I adapt this so the outcome of ((11+(1,5*(AANTAL.ALS(P5:P16;("~<*"))))+(1,5*(AANTAL.ALS(P5:P16;"<1")))) is not greater then 16
=TEKST.SAMENVOEGEN((11+(1,5*(AANTAL.ALS(P5:P16;("~<*"))))+(1,5*(AANTAL.ALS(P5:P16;"<1"))))&("µl PAL + 6µl PhiX + ")&(594-(11+(1,5*(AANTAL.ALS(P5:P16;("~<*"))))+(1,5*(AANTAL.ALS(P5:P16;"<1")))))&("µl HT1"))
Thx in advance!
An
Bookmarks