Is this a bug?

Ask for Help
1

Hi all

So I’m wondering if the below is a bug? I would have thought the IF THEN column would have shown exactly what was in either of the two preceding columns but it is stripping out the $ sign and the period and cents value?? Is there a way to stop it doing this?

Thanks

image
image493×470 28.7 KB

2

The IF column always uses the underlying value without any formatting or precision applied. Your best bet is to use a math column to apply formatting to the IF column result.

3

Ahhh, that’s the trick! Thanks!

1 Like
4

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.