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!

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!

puiuluipui;297286 Wrote:
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
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=83092

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!

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!