I have 3 formula columns, each calculating a number, which I have formatted using the text(x,"$#,##0.00").
I’d like to add these formula columns together in a 4th formula column ie {formula1}+{formula2}+{formula3}, but this doesn’t work.
- Is this because the text function means the value is no longer recognised as a number?
- If so, how can I show all formula columns in number format $0.00 and Monday still recognise it as a number?
Thanks!