Rounding numbers

[JackO]

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)

 

[IML]

=roundup(yourformula,0)

 

[Andrew Poulsom]

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)

 

[inarbeth]

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