Rounding formula & Range

[andrewb23]

Hi there! looking to get some assistance in creating a formula that will take a 7 digit number such as $1,680,000 and create a range of $1.7 - 1.8 MM

Two components here, the rounding, and then creating a range of 100k. Really struggling with this one. 

[gawa]

hi @andrewb23 Assume you are using Designer Desktop....here is the solution by simply using Formula tool.

You need to define in which "$1.6-1.7MM" or "$1.5-1.6MM" $1,600,000 should fall.(In my WF, I included it in "$1.6-1.7MM")

[andrewb23]

Thank you so much!