Add Roundup to existing formula

[Lainbow]

Help a basic Excel user!

Can someone please give me the formula to add ROUNDUP to this existing formula =SUM('A1 2-Bed Hot Tub'!F84*110%)

 

[Georgiboy]

Welcome to the forum,

Try:

=ROUNDUP(SUM('A1 2-Bed Hot Tub'!F84*110%),0)

The zero at the end denotes how many digits to round to, zero will return a whole number.

 

[Lainbow]

Welcome to the forum,

Try:

=ROUNDUP(SUM('A1 2-Bed Hot Tub'!F84*110%),0)

The zero at the end denotes how many digits to round to, zero will return a whole number.

 

[Lainbow]

Thank you for your reply Georgiboy.

I tried that but now I am getting the #REF! error

 

[Georgiboy]

What does your original formula display?:

=SUM('A1 2-Bed Hot Tub'!F84*110%)

That error seems to point out that excel can't find the range: 'A1 2-Bed Hot Tub'!F84

You could try constructing the formula again and selecting the cell on the other sheet. Then wrap your formula in the ROUNDUP the same way i did.

 

[Joe4]

Does you original formula return a value or a #REF! error?

=SUM('A1 2-Bed Hot Tub'!F84*110%)

If it returns a #REF! error, then the error is probably with your sheet name reference. You may want to double-check that to make sure you have that right.

Since you are only referencing one cell, I don't think the SUM function serves any purpose. So you should be able to just use:

=ROUNDUP('A1 2-Bed Hot Tub'!F84*110%,0)

If that returns an error, please confirm what is in cell F84 there.
Is it a valid numeric entry?

What does the following formula return?

=ISNUMBER('A1 2-Bed Hot Tub'!F84)

 

[Lainbow]

The =SUM('A1 2-Bed Hot Tub'!F84*110%) formula entered into the cell returns a value.

Basically I am trying to use Sheet A1 to input my base rates. Sheet A1 - F84 contains the value £465.00. I used the above formula to add 10% for the same cell in Sheet A2. As this now takes the value to £511.50 I would like to round it up.

I have tried....

=ROUNDUP('A1 2-Bed Hot Tub'!F84*110%,0) and get the #REF! Error

=ISNUMBER('A1 2-Bed Hot Tub'!F84) and get the FALSE Error.

Sorry for my lack of knowledge.

 

[Joe4]

=ISNUMBER('A1 2-Bed Hot Tub'!F84) and get the FALSE Error.

That is NOT an error.
What that is telling your is that your value enter in cell F84 is NOT a valid number!
It may be a number entered as text.

What exactly is in this cell? Can you show us an example?
Where exactly is this value in cell F84 coming from?
Is it the result of a formula? Is it imported? Is it manually entered?

If it is the result of a formula, please post that formula.