Ceiling problem.

[puiuluipui]

Hi, i have a small problem with ceiling formula. I use this two formula:
=CEILING(A1,Sheet3!A1:A12)-A1
=CEILING(A1,Sheet3!A1:A12)
In Sheet3!A1:A12, i have 10.000,20.000,30.000...120.000 etc.
The problem is that the formula is not finding the correct value in
Sheet3!A1:A12.
If the formula is in row 1 it's looking at Sheet3!A1
If the formula is in row 2 it's looking at Sheet3!A2
Or can i make this formula something like :
=CEILING(A1,10.000,20.000,30.000,40.000,50.000)-A1

Thanks!

 

[Niek Otten]

Are you sure you don't need MAX() instead of CEILING()?

 

[Pecoflyer]

Hi, i have a small problem with ceiling formula. I use this two
formula:
=CEILING(A1,Sheet3!A1:A12)-A1
=CEILING(A1,Sheet3!A1:A12)
In Sheet3!A1:A12, i have 10.000,20.000,30.000...120.000 etc.
The problem is that the formula is not finding the correct value in
Sheet3!A1:A12.
If the formula is in row 1 it's looking at Sheet3!A1
If the formula is in row 2 it's looking at Sheet3!A2
Or can i make this formula something like :
=CEILING(A1,10.000,20.000,30.000,40.000,50.000)-A1

Thanks!

Have a look at the syntax of the CEILING function


--
Pecoflyer

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows file
upload ->faster and better answers

*Adding your XL version* to your post helps finding solution faster

 

[puiuluipui]

I really dont know. Can you help me with a new formula?

Thanks!

"Niek Otten" a scris:

 

[Niek Otten]

What are you trying to achieve?