Hi! I am trying to create a simple If formula that shows how much my clients owe me. So if the amount billed is equal to the amount paid, show £0 else show the balance.
My issue is, I am trying to append the £ sign before the balance calculation but it doesn’t work.
IF({Amount Billed}={Amount Paid}, “£0”, ‘£’ & {Amount Billed}-{Amount Paid})
It only works if I place the £ after the balance.
IF({Amount Billed}={Amount Paid}, “£0”,{Amount Billed}-{Amount Paid}&’ £’)
Any help on how I can accomplish this?
