Probably simple Excell question

[Skunkworks]

I need what is probably a very simple spreadsheet, but I only know the very basics of Excell.

I need the A, B & C cells to be rounded down to the nearest 200, then divided by 200, then multiplied together and the answer displayed in D as shown below.

 

[AHarvey]

Why not just post this in the programming thread you've already got covering the same thing?

Paste into D1 and drag down

=SUM(INT(A1/200)*INT(B1/200)*INT(C1/200))

 

[Skunkworks]

Becuase I didn't think there'd be that much of a crossover between programming and Excell.

Thanks for the help.