These 2 formula work as expected; individually.
But for the life of me I can’t combine the 2 without running into issues.
Would very much appreciate help on it!!
Excel Formula:
=IF(AND(RIGHT(D32,FIND(" ",D32)-1)="kg",TRUNC(D23)>0),TRUNC(D23)*(D14*1000)/D18)*(LEFT(D20,FIND(" ",D20))/1000)&" "&F26
=IF(AND(RIGHT(D32,FIND(" ",D32)+1)="lts",TRUNC(D23)>0),TRUNC(D23)*(D14*1000)/D18)*(LEFT(D20,FIND(" ",D20))/1000)&" "&F25
Would very much appreciate help on it!!