#### Caly

##### Board Regular

- Joined
- Jul 19, 2015

- Messages
- 160

- Office Version
- 365
- 2013
- 2011
- 2010
- 2007

- Platform
- Windows

=if(and(A2>10,000,A2<100,000),roundup(A2,-4),

if(and(A2>100,000,A2<1,000,000),roundup(A2,-5),

if(and(A2>1,000,000,A2<1,000,000,000),roundup(A2,-6),

Roundup(A2,-7))))

Column A - Dollars

$12,036,219.22

$437,379.70

$11,737.18

$180,595.28