Many thanks for your help with this usafmeinweg
I see the code,,, you have for cell AA38
=IF(COUNTBLANK($AA$6:$AA$7),"",IF(Z38*$AA$37>$S$6,$S$6,Z38*$AA$37))
That's great,,,
I've just got another reply from VOG on Mr.Excel
his is;
=MIN(S6,Z38*$AA$37)
Seems to work also.....

Thing is,, I need to try now and see how these all work with S15,S18 & S21 working..
Again, thanks for this usafmeinweg,,,,,
maybe your formula can be adjusted for these other 3 cells?