formula to convert ml to litres automatically to a specific column

[JEAN1972]

I have a break down sheet from from packs /per packs /litrage which is both ml and litres only..

The data in column D is only litres from column C which is both ml and litres .

The ML in column C format is always three digits 200 , 150 ,375.

the ml is converted to litres by dividing by 1000

The Litres in column C format is always in format 1 ,10, 10.5 litres.

looking formula to convert the data from column C to D automatically

[Bendigus]

Are you just asking how to automatically divide a cell by 1000

For example in

D2 you could do =C2/1000

[Stormin']

Just use an IF() function to decide whether it is 3 digits or more

Please Login or Register  to view this content.

[Phuocam]

Try:

=IF(C2="","",IF(C2<100,C2,C2/1000))