Help

Cannot append text before number in If statement

Solved
Jump to Solution
574 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Yaw
4 - Data Explorer
4 - Data Explorer

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?

1 Solution

Accepted Solutions
ScottWorld
18 - Pluto
18 - Pluto

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.

See Solution in Thread

2 Replies 2
ScottWorld
18 - Pluto
18 - Pluto

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.

It worked! Thank you!