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)
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)