Hello,

your " appriopriate value" can be calculated suing the CEILING
function.

So the difference would be something like =ceiling(a1,10000)-a1

You other questions can be solved the same way

HTH

puiuluipui;294917 Wrote:
Hi, i need to calculate the diferences between actually cars km, and
the
inspection km limit.

I have an database with 35 rows, and in every monday i will write cars
km
starting from "J" column to "BG" column.

A... F G... J
K... BG
4 first car 1.325 km 30.000 km 28.675 km
5 second car 9426 km 60.000 km 50.574 km
6 third car 5475 km 40.000 km 29.012 km 34525
km

Inspections are at 10.000km; 20.000km; 30.000 km; ........120.000 km

I need the formula in "F" and to calculate the diferences from last
cell in
row 4, and the apropriate value (ex: "last cell"=9000 km
.....appropriate
value to be 10.000 km ; "last cell"=75.000 km .....appropriate value to
be
80.000 km...etc )

In "G" i need another formula to tell me what appropriate value (next
inspection km) it used.


If car has now 15.000 km (J....BG), that means that the next inspection
is
at 10.000 km and in "F" i need the formula to show me 5.000 km
(remaining).
In "G" to view 10.000 km.
Can this be done?


Thanks in advance.


--
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=82425