Userform formulas

[Apple08]

Hi everyone

I have a formula as below but it doesn't work:

TextBoxE20.Value = Format(WorksheetFunction.Ceiling(Val(WordCount) / Range("$D$22") + WorksheetFunction.Ceiling(Val(WordCount) / Range("$E$22") * 1.15, 0.25)), "0.00")

The word 'Ceiling' is highlighted as error. Please could anyone help? Many thanks.

 

[RoryA]

Ceiling requires two arguments. You have only passed one to the first instance of the function.

 

[Apple08]

Shall I remove Celiing from the code?

 

[RoryA]

How should I know - I don't know what you're trying to do?

 

[Apple08]

Actually I want to round up the calculation to the nearest 0.25, 0.5 or 0.75.

The sum of WordCount/Range (D22) then add the sum of WordCount/Range (E22)

 

[RoryA]

Where does the *1.15 come into it?

 

[Apple08]

Oh yes, I need to add 15% on top of the calculation of WordCount/E22

 

[RoryA]

Then I think you want this:

TextBoxE20.Value = Format(WorksheetFunction.Ceiling(Val(WordCount) / Range("$D$22") + (Val(WordCount) / Range("$E$22")) * 1.15, 0.25), "0.00")

 

[Apple08]

Thanks! It works perfectly!

 

[RoryA]

Glad to help.