Adding "$" sign to an ABS formula

Lynell Mulvihill

I'm doing a round-up 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?

Stefan

Hi @Lynell Mulvihill,

if you don't set the column to be Dollar, then you could add it like this:

="$"+ IF(ABS(Budget55)...

Hope this helps

Stefan

Lynell Mulvihill

So simple and that worked! Thank you

Stefan

Pleasure :-) @Lynell Mulvihill