Format number in IF-THEN column

Ask for Help
1

Hi, Gliders,

I have a math column that I have formatted to $XX.XX. However, I also need that result elsewhere in an IF-THEN column. Is there a way to format the result of the IF-THEN column for the dollar sign and two decimal points?

Thanks,
Mona

2

If you pass that math value through a template column, it should lock in the formatting.

2 Likes