Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Oct 22, 2022 02:46 AM
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?
Solved! Go to Solution.
Oct 22, 2022 02:51 AM
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.
Oct 22, 2022 02:51 AM
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.
Oct 22, 2022 02:54 AM
It worked! Thank you!