Format number in a ROUND formula

[jski]

So I downloaded the Create Intuitive Dashboards file and the up and down symbols work well with my data. However, selecting the "Use 1000 separator" box does nothing; the number format doesn't seem to permit to use a comma to show thousands, millions , etc. Here's the ROUND formula contained in the file:

=ROUND(C10,0) & " " & IF(C9<C10,"▲", IF(C9=C10,"●","▼"))


Many thanks in advance for your consideration and assistance.


jski

 

[Luke M]

Hi, and welcome to the forum:
I'm guessing the formula needs to be something like
=TEXT(ROUND(C10,0),IF(SomeCell,"#,##0","0") & " " & IF(C9<C10,"▲", IF(C9=C10,"●","▼"))

Where the SomeCell is the reference to wherever the Use 1000 separator check box goes to. Hopefully you can find some other cell in the tool that references this. Basically, the TEXT function is what is going to do the formatting for us, and so if SomeCell = True, then format with commas, otherwise don't.

 

[jski]

I'm guessing the formula needs to be something like
=TEXT(ROUND(C10,0),IF(SomeCell,"#,##0","0") & " " & IF(C9<C10,"▲", IF(C9=C10,"●","▼"))

Where the SomeCell is the reference to wherever the Use 1000 separator check box goes to. Hopefully you can find some other cell in the tool that references this. Basically, the TEXT function is what is going to do the formatting for us, and so if SomeCell = True, then format with commas, otherwise don't.

Luke,

Beautiful. Thanks!


jski