Formula to show text next to sum amount

Waleed
Waleed ✭✭✭
edited 01/30/21 in Formulas and Functions

Good day,

Our Currency ( BHD for Bahrain Kingdom ) is not one of listed currencies and I wish to show it to amount numbers , how to have Currency BHD seen next tp total sum in below formula ?

=SUM([Service Charge]4:[Service Charge]13)

Also , is there a way or formula to show text ( BHD ) or any other text next to number for price amounts ?

Thank you

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!