Hi All,

I was windering if you can help, I am helping my friend who runs a mall auction housr, and am trying to find the correct formula for an invoice he would produce to someone who gave him goods to sell.

If the value of any item sold is less then £5, then the minimum charge would be £1 (I know this works out at IF<6.666666)
but if the value os over this amount then the charge incurred would be 15% (so anything above 6.666 would be 15% of selling price). I can get this to work in a single cell....but not for multiple cells...HELP!!!