Hi Edwin,

Am Wed, 6 Aug 2014 07:42:58 +0100 schrieb edwinhwhw87:

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

in F2 try:
=MAX(B2%*C2%*D2%;E2/1000)

then go to the right lower edge of the cell F2 till the cursor changes
to a black + sign and drag the formula with pressed left mouse button
down


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional