Cannot append text before number in If statement

[Yaw]

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?

[ScottWorld · Accepted solution]

Welcome to the community, @Yaw!

Do not include the symbol anywhere in your formula, and also do not put any of your numbers (such as the 0) within quotation marks.

Then, you can choose the formatting option on the field to add the symbol.

[Yaw]

Yaw:

£

It worked! Thank you!