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]

Welcome to the Board!

What do the values that is it returning from column G look like?
How exactly do you want them rounded (explain in plain English, the danger of trying to interpret from coding is that if your coding is wrong, our interpretation of what you are trying to do could be wrong).

 

[bnkyaong]

Hi Joe4,

The value is a fraction, ie 31-1/2", i wanted to round it up to 32".

Thank you,
bnkyaong

 

[St Jimmy]

Is the value stored as text or as numeric? For example, is the value 31.5 or 31-1/2" ?

 

[Joe4]

Assuming those values being returned are numeric and not text, try:

[COLOR=#333333]=IF($B8="","",ROUND(VLOOKUP($B8,'Type D Box Col Data '!$C$4:$H$260,5,0),0))[/COLOR]

 

[bnkyaong]

Is the value stored as text or as numeric? For example, is the value 31.5 or 31-1/2" ?

Hi St Jimmy,

The value stored as numeric.

Thank you,
bnkyaong

 

[bnkyaong]

Hi Joe4,

I want the answer for the entire formula to be rounded up not just the first part of it.

Thank you,
bnkyaong

 

[Joe4]

Note that if you really want to always round up, so that a value like 31.25 rounds up to 32, then just use ROUNDUP instead of ROUND, i.e.

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

If it does not work for you, please provide an example of a value that is not working (and tell us what you expected answer should be).

 

[bnkyaong]

Hi Joe4,

=IF($B8="","",(VLOOKUP($B8,'Type D Box Col Data '!$C$4:$H$260,5,0)*2)+1+(2*C8)+2)
with the formula above i'm getting an answer equal to 30-1/2"
i want to roundup this answer to 31"
'Type D Box Col Data '!$C$4:$H$260,5,0) has a value of 11"
C8 has a value of 2-3/4"

I'm actually trying to use roundup and not round. Doesn't your formula above just rounds up the first portion of
my entire formula ( underlined above )?. When i try to insert your roundup formula on the first portion of my
formula i get an error message.

Thank you,
bnkyaong

 

[St Jimmy]

[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]

Does that work?