I got a formula

=IFERROR(IF(D3="","",IF(D3<0,D3*(('MLB OVERALL'!$O$2*'MLB OVERALL'!$B$3)+$A$4)/-100,
(('MLB OVERALL'!$O$2*'MLB OVERALL'!$B$3)+'Week 1a'!$A$3)/$D3*100)), "")
however I want to round it up to the next dollar

so if it is 1.10 its 2 dollars etc if its 1.99 roundup to 2.00 never any decimals.


I tried

=IFERROR(ROUNDUP((IF(D3="","",IF(D3<0,D3*(('MLB OVERALL'!$O$2*'MLB OVERALL'!$B$3)+$A$4)/-100,
(('MLB OVERALL'!$O$2*'MLB OVERALL'!$B$3)+'Week 1a'!$A$3)/$D3*100)), ""),0)
But it did not work???

Matt