Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Cannot append text before number in If statement

Solved
Jump to Solution
117 2
cancel
Showing results for 
Search instead for 
Did you mean: 

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

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

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!