Roundup

[bnkyaong]

Hi Guys,

I've been trying to roundup the result of this formula but i can't
seem to make it work. Can anybody please help me.

=IF($B8="","",(VLOOKUP($B8,'Type D Box Col Data '!$C$4:$H$260,5,0)*2)+1+(2*C8)+2)

Thanks in advance,

bnkyaong.

 

[Joe4]

If you want to apply to ROUNDUP to the second part, then just enclose that entire part in ROUNDUP, i.e.

[COLOR=#333333]=IF($B8="","",ROUNDUP[/COLOR][U](VLOOKUP($B8,'Type D Box Col Data '!$C$4:$H$260,5,0)[/U][COLOR=#333333]*2)+1+(2*C8)+2),0)[/COLOR]

 

[bnkyaong]

Hi St Jimmy,

Nope, i already tried that.

Thank you,
bnkyaong

 

[Joe4]

Nope, i already tried that.

Jimmy and I posted the same formula, and it returns 31 for me.
If it does not for you, then either your VLOOKUP is not returning what you think it is, or C8 is not really equivalent to 2.75.

 

[St Jimmy]

What does it return when you try it? An incorrect number or an error? Details would help