Thanks for your suggestion.
I actually had a response from Woocommerce via another route and their advice was to leave out the brackets. This worked (BIDMAS Order of Ops), so problem solved.
It’s just odd that my formula was exactly as Woocommerce instructions (plus all the youtube videos I checked).
Thanks again for taking the time to reply.