What are you trying to achieve?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"puiuluipui" wrote in message
...
I really dont know. Can you help me with a new formula?

Thanks!

"Niek Otten" a scris:

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"puiuluipui" wrote in message
...
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!