Great answer, I went with the middle option as AsCurrency (Float) is deprecated, and AsCurrency doesn’t have the same options.
For anyone needing to implement this solution, I’d suggest abstracting it into a pure function as such Works great, thanks Denny