Thanks Skye, yes good spot. Fixed that but still not working. I've tried shortened versions of the formula with less currencies but to no avail, I'd reached the conclusion there must be something fundamentally wrong with my formula. For example the following doesn't work either ROUND(IF(Currency="AU...