Help

Discover what data silos are costing your org in our commissioned Forrester study. Learn more

Cannot append text before number in If statement

Solved
Jump to Solution
65 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!