If formula...?

[puiuluipui]

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]

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

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

 

[puiuluipui]

Hi, i need the code to contain all appropriate value (10.000km, 20.000km,
30.000km, 40.000km, 50.000km, 60.000km, 70.000km, 80.000km, 90.000km,
100.000km, 110.000km, 120.000km), with or without "km", and to look in last
cell of row 1. I will add km every week, but i need to calculate only the
last cell containing km.

Your formula is working, but it's not containing all appriopriate value and
it doesn't look in the last written cell of the row.

Ex:
j k l m
10125km 24327km 29.985km 34.001km

Cell "M" is the last written cell. I need the code to look in "M" and ignore
the rest cells.

Can this be done?

Thanks!



"Pecoflyer" a scris: