This is wrong because your value of 26 unit after deduction Discount Amount is shown 975 ...

Actual value show is 650 after deduction so your formula is wrong

]]>This is wrong because your value of 26 unit after deduction Discount Amount is shown 975 ...

Actual value show is 650 after deduction so your formula is wrong

]]>Actual value show is 650 after deduction so your formula is wrong

]]>=(C7*$D$5)-(C7*$D$5)*ArrayFormula(max((C7>$F$7:$F$12)*$G$8:$G$13))

]]>I tried with this formula and it is working fine (based on salary is paid exactly after 7 days IE 8th day only accumulating 200$).

=IF(AND(WEEKDAY(B7)=7, SUM(C1:C7) > 200), "Payment Due " & SUM(C1:C7), IF(AND(WEEKDAY(B7) = 1, ISBLANK(E7)), SUM(C1:C7)))

Regards,

Faizan

]]>Probably not easily

But seeing as the merge is done using VBA you could use that to save the file with the appropriate name

e.g Document For [Jeff]

Jeff being the name of the person the letter is being drafted for. So in my destination folder I can just generate as many as I want without fear of the file being over written.

]]>