Dear all,

In the course of my work I do lots of calculations similar to the attachment enclosed below.

1. Dimensions have to be converted to cubic metres
2. Weight has to be converted to metric tons
3. RT column chooses between volume or weight value, whichever is greater

Typical RT formula : =IF(B2*C2*D2/1000000E2/1000,B2*C2*D2/1000000,E2/1000)

It's really simpler and faster to compute using a calculator, however, with excel formulas, errors in calculation are massively minimised.

Herein lies the problem - my spreadsheets are hundreds of items long. If I have to manually insert formula for every RT cell, it will take hours and that of course will be counter productive.

Is there any way in which Excel 2013 can autofill or be formatted to automatically insert the formula with some minor changes?

Example of how my formula differs in RT column, from cell to cell:-

F2 =IF(B2*C2*D2/1000000E2/1000,B2*C2*D2/1000000,E2/1000)
F3 =IF(B3*C3*D3/1000000E3/1000,B3*C3*D3/1000000,E3/1000)
F4 =IF(B4*C4*D4/1000000E4/1000,B4*C4*D4/1000000,E4/1000)

and the list goes on.

Many many thanks in advance.