=IF(OR($K$15=0,$K$16=0,$K$17=0,AND($L31="yes",$N31>$M31),AND($L31="yes",$N31>$K$16*$O$28%),IF(SUMIFS($N$31:$N$39,$L$31:$L$39,"yes",$M$31:$M$39,">0")>=$K$16,N31,0)>=($K$16-SUMIFS($N$31:$N$39,$L$31:$L$39,"yes",$M$31:$M$39,">0"))),"-",

IF(IsPPM,

IF($L31="yes",

IF(OR($J31="",$O31=""),"-",IF(($R31/$M31*1000)/INDEX(SS!$H$29:$H$48,MATCH(DIYTraceCalculator!G31,SS!$B$29:$B$48,0))<1,IF($R31="-","-","Add "&ROUND($R31,2)&" gr of '"&$H31&"' to your "&$M31&" ml stock container, then add "&$N31&" ml of that solution to your "&DIYTraceAdjustedMicroVolume&" ml " &IF(AIO="yes","AIO","Micro")&" container."),"Trace Solubility Exceeded ("&ROUND(($R31/$M31*1000)/INDEX(SS!$H$29:$H$48,MATCH(DIYTraceCalculator!G31,SS!$B$29:$B$48,0))%,1)&" %) - Increase ml taken from stock solution to " &IF(AIO="yes","AIO","Micro")&" container.")),

IF($L31="no",

IF($J31="","-",IF(($S31/$K$16*1000)/INDEX(SS!$H$29:$H$48,MATCH(DIYTraceCalculator!G31,SS!$B$29:$B$48,0))<1,IF($S31="-","-","Add "&ROUND(S31,2)&" gr of '"&$H31&"' to your " &IF(AIO="yes","AIO","Micro")&" container."),"Trace Solubility Exceeded ("&ROUND(($S31/$K$16*1000)/INDEX(SS!$H$29:$H$48,MATCH(DIYTraceCalculator!G31,SS!$B$29:$B$48,0))%,1)&" %) - Try increasing your daily dosage in the TankAndDosing sheet.")),"-")),

IF(IsGrams,

IF($L31="yes",

IF(OR($I31="",$O31=""),"-",IF(($I31/$M31*1000)/INDEX(SS!$H$29:$H$48,MATCH(DIYTraceCalculator!G31,SS!$B$29:$B$48,0))<1,IF($R31="-","-","Add "&ROUND(R31,2)&" gr of '"&$H31&"' to your "&$M31&" ml stock container, then add "&$N31&" ml of that solution to your "&DIYTraceAdjustedMicroVolume&" ml " &IF(AIO="yes","AIO","Micro")&" container."),"Trace Solubility Exceeded ("&ROUND(($I31/$M31*1000)/INDEX(SS!$H$29:$H$48,MATCH(DIYTraceCalculator!G31,SS!$B$29:$B$48,0))%,1)&" %) - Increase ml taken from stock solution to " &IF(AIO="yes","AIO","Micro")&" container.")),

IF($L31="no",

IF($I31="","-",IF(($I31/$K$16*1000)/INDEX(SS!$H$29:$H$48,MATCH(DIYTraceCalculator!G31,SS!$B$29:$B$48,0))<1,IF($S31="-","-","Add "&ROUND($S31,2)&" gr of '"&$H31&"' to your " &IF(AIO="yes","AIO","Micro")&" container."),"Trace Solubility Exceeded ("&ROUND(($I31/$K$16*1000)/INDEX(SS!$H$29:$H$48,MATCH(DIYTraceCalculator!G31,SS!$B$29:$B$48,0))%,1)&" %) - Try increasing your daily dosage in the TankAndDosing sheet.")),"-")),"-")))