Error when using roundup and index in same formula

[Sylver75]

I've searched your forum, and this post came close, but not quite the same: Spill dynamic array across multiple columns with a defined depth.
I have an excel sheet that looks as below:

my current formula:
=INDEX(Business!B2:L7, MATCH(B3,Business!B2:B7,0)9)*100
Check a designated list against column B, and gives the correct % results (on example above, it would check Description B and return results 35).

I tried to add a roundup to it: =ROUNDUP(INDEX(Business!B2:L7, MATCH(B3,Business!B2:B7,0)),9)*100 but I get error #REF.
When I evaluate the steps, it shows:
=ROUNDUP(INDEX(Business!B2:L7, MATCH(B3,Business!B2:B7,0)),9)*100

=ROUNDUP(INDEX(Business!B2:L7, MATCH(B,Business!B2:B7,0)),9)*100

=ROUNDUP(INDEX(Business!B2:L7,2),9)*100

=ROUNDUP(#REF!,9)*100

#REF!*100

#REF!

I think the problem might be in the second parenthesis added after number 0, however if I try adding the parenthesis at the end or anywhere else, I get an error: "You've entered too few arguments for this function".

Any help is appreciated.

 

[Sylver75]

I didn't write it in the previous post, but I'm using excel 2016.

 

[Joe4]

Welcome to the Board!

ROUNDUP has TWO arguments, the value you want to round, and how many digits you want to round it to.
You left off the second argument.
See: How to use the Excel ROUNDUP function | Exceljet

 

[Fluff]

You are indexing B2:L7, but haven't said which column it should pull the value from. Which column do you want to return?

 

[Sylver75]

You are indexing B2:L7, but haven't said which column it should pull the value from. Which column do you want to return?

The indexing part works perfectly. if the original number is 0.3597854, then the result shows 35.97854 (and in excel it does show 36 which is perfect).
I'm trying to use ROUNDUP on top of it for those pesky numbers like 0.00034562, then the result is 0.034562 (and in my excel sheet shows as 0). But if there's any number that is not EXACTLY 0 like this example, I want it to show 1.

 

[Sylver75]

Welcome to the Board!

ROUNDUP has TWO arguments, the value you want to round, and how many digits you want to round it to.
You left off the second argument.
See: How to use the Excel ROUNDUP function | Exceljet

I see your response, and probably that is the issue, but I can't figure out where to add the whole number roundup for the entire results. Basically work the Index number and multiply by 100, THEN roundup.

 

[Fluff]

The indexing part works perfectly.

If that is the case why did you post that it was returning a #REF! error?

 

[Joe4]

I see your response, and probably that is the issue, but I can't figure out where to add the whole number roundup for the entire results. Basically work the Index number and multiply by 100, THEN roundup.

Roundup to what? The nearest 10, 100, 1000, etc?
Did you look at the link I provided? It shows you.

If your INDEX formula is correctly returning a value, then just structure is like this:
=ROUNDUP(your original formula, X)
where "X" is the number of digits you want to roundup too (as shown in my link).

 

[Sylver75]

Roundup to what? The nearest 10, 100, 1000, etc?
Did you look at the link I provided? It shows you.

If your INDEX formula is correctly returning a value, then just structure is like this:
=ROUNDUP(your original formula, X)
where "X" is the number of digits you want to roundup too (as shown in my link).

=ROUNDUP(INDEX(Business!B2:L7, MATCH(B3,Business!B2:B7,0)9)*100), 0)
Returns error "You've entered too few arguments for this function".

 

[Sylver75]

=ROUNDUP(INDEX(Business!B2:L7, MATCH(B3,Business!B2:B7,0)9)*100), 0)
Returns error "You've entered too few arguments for this function".

I apologized, I figured out the issue.
Missing one parenthesis.
=ROUNDUP((INDEX(Business!B2:L7, MATCH(B3,Business!B2:B7,0)9)*100),0)
Needed two parenthesis before Index.

Thank you for all your help.