Caly
Board Regular
 Joined
 Jul 19, 2015
 Messages
 128
 Office Version

 365
 2013
 2011
 2010
 2007
 Platform

 Windows
Hi I have multiple dollar value ranges and am trying to apply one formula for each option but is there a better way to write the formula below?
=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
=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