Hi,

Im trying to do an invoice for my friends small ironing business and the minimum order is £20. Can any one tell me how I can come to this total I know how to use the =sum(D19:G19) but if the total is less than £20 i need the total to be £20. hope that makes sense.


The other tricky thing is the first 15 items and £1.35 and after that are 90p each can I use a formula for that?

Your help is much appreciated.