Rounding numbers :: MrExcel Message Board
 Search   Memberlist   Usergroups   Favorites   Statistics   Register

 Rounding numbers

JackO
Welcome to the Board

Joined: 28 Oct 2002
Posts: 4

Status: Offline

Rounding numbers

I have a formula in a cell (A23 - example) that usually returns a decimal such as say 3.2 for an example. I want to round this number up each time, but when I use the ROUNDUP function for that cell I get a circular reference.
ROUNDUP(A32,0) is there another way to write this so it will round up?

This is the formula I have in cell A23, I want to roundup the result of this formula each time
=IF(H14<1,"",INDEX(\$U\$94:\$BD\$134,MATCH(B14,\$U\$94:\$U\$134,),MATCH(C14,\$U\$94:\$BD\$94,))*H14)

Fri Sep 19, 2003 3:50 pm

IML
MrExcel MVP

Joined: 16 Feb 2002
Posts: 1361
Location: Denver, CO
Flag:

Status: Offline

Re: Rounding numbers

=roundup(yourformula,0)

Fri Sep 19, 2003 3:52 pm

Andrew Poulsom
MrExcel MVP

Joined: 22 Jul 2002
Posts: 8266

Flag:

Status: Offline

Re: Rounding numbers

Like this?

=ROUNDUP(IF(H14<1,"",INDEX(\$U\$94:\$BD\$134,MATCH(B14,\$U\$94:\$U\$134,),MATCH(C14,\$U\$94:\$BD\$94,))*H14),0)

Fri Sep 19, 2003 3:54 pm

inarbeth
Board Master

Joined: 09 Apr 2002
Posts: 611
Location: Wivenhoe, England
Flag:

Status: Offline

Re: Rounding numbers

Hi, welcome to the board.
Won't =ROUNDUP(IF(H14<1,"",INDEX(\$U\$94:\$BD\$134,MATCH(B14,\$U\$94:\$U\$134,),MATCH(C14,\$U\$94:\$BD\$94,))*H14),0)

give you the result you want?

Looks like I was beaten to the draw
_________________

Fri Sep 19, 2003 4:04 pm
 Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First

Forum Jump:
 Jump to: Select a forum MrExcel Forums----------------Excel QuestionsInternational forumMicrosoft AccessTechnical issues and Future development Holy Macro! Books----------------Holy Macro! Products The Lounge----------------Max Cells Lounge Announcements----------------About This BoardHall of Fame WinnersTest Here

Page 1 of 1

Forum Rules:
 You cannot post new topics in this forumYou cannot reply to topics in this forumYou cannot edit your posts in this forumYou cannot delete your posts in this forumYou cannot vote in polls in this forum