Adding "$" sign to an ABS formula
I'm doing a roundup formula for budgets and the formula works $8,378,398 shows round to 8.38M  formula is =IF(ABS(Budget55) >= 10 ^ 9, ROUND(ABS(Budget55) / 10 ^ 9, 2) + "B", IF(ABS(Budget55) >= 10 ^ 6, ROUND(ABS(Budget55) / 10 ^ 6, 2) + "M", IF(ABS(Budget55) >= 10 ^ 3, ROUND(ABS(Budget55) / 10 ^ 3, 2) + "K", ABS(Budget55))))  QUESTION how can I add the "$" sign to the formula?
Answers

if you don't set the column to be Dollar, then you could add it like this:
="$"+ IF(ABS(Budget55)...
Hope this helps
Stefan
Smartsheet Consulting, Solution Building, Training and Support.
Projects for Processes and for People.

So simple and that worked! Thank you

Pleasure :) @Lynell Mulvihill
Smartsheet Consulting, Solution Building, Training and Support.
Projects for Processes and for People.
Help Article Resources
Categories
Check out the Formula Handbook template!