I am using a formula to determine time per unit produced and one of the
pieces of data is based on the number of stations on the production line
minus one (L2-1). What I need to do is have the condition set that if L2 is
greater than K2 (quantity) use L2-1 if it is not greater than K2 then us L2.
Can anyone help me?

If there is anyone using formulas to produce production data in a
manufacturing environment, any information you have would be most helpful.

=IF(L2K2,L2-1,L2)
--
Gary's Student


"Valerian" wrote:

I am using a formula to determine time per unit produced and one of the
pieces of data is based on the number of stations on the production line
minus one (L2-1). What I need to do is have the condition set that if L2 is
greater than K2 (quantity) use L2-1 if it is not greater than K2 then us L2.
Can anyone help me?

If there is anyone using formulas to produce production data in a
manufacturing environment, any information you have would be most helpful.

Try this formula

=L2-(L2K2)


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=526365