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!