software

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.=M2/(K2 (L2-1))
the above is the current formula I am using so what you are saying is I can
do this...
=M2/(K2 (=IF(L2gt;K2,L2-1,L2)))quot;Gary''s Studentquot; wrote:

gt; =IF(L2gt;K2,L2-1,L2)
gt; --
gt; Gary's Student
gt;
gt;
gt; quot;Valerianquot; wrote:
gt;
gt; gt; I am using a formula to determine time per unit produced and one of the
gt; gt; pieces of data is based on the number of stations on the production line
gt; gt; minus one (L2-1). What I need to do is have the condition set that if L2 is
gt; gt; greater than K2 (quantity) use L2-1 if it is not greater than K2 then us L2.
gt; gt; Can anyone help me?
gt; gt;
gt; gt; If there is anyone using formulas to produce production data in a
gt; gt; manufacturing environment, any information you have would be most helpful.
gt; gt;

=IF(L2gt;K2,L2-1,L2)
--
Gary's Studentquot;Valerianquot; wrote:

gt; I am using a formula to determine time per unit produced and one of the
gt; pieces of data is based on the number of stations on the production line
gt; minus one (L2-1). What I need to do is have the condition set that if L2 is
gt; greater than K2 (quantity) use L2-1 if it is not greater than K2 then us L2.
gt; Can anyone help me?
gt;
gt; If there is anyone using formulas to produce production data in a
gt; manufacturing environment, any information you have would be most helpful.
gt;


Try this formula

=L2-(L2gt;K2)--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=526365Almost...Just omit that internal = sign.=M2/(K2 (IF(L2gt;K2,L2-1,L2)))

If you use a function like IF() inside an expression, you don't need the
equal sign inside (Excel will complain if you include it.)

Have a good weekend
--
Gary's Studentquot;Valerianquot; wrote:

gt; =M2/(K2 (L2-1))
gt; the above is the current formula I am using so what you are saying is I can
gt; do this...
gt; =M2/(K2 (=IF(L2gt;K2,L2-1,L2)))
gt;
gt;
gt; quot;Gary''s Studentquot; wrote:
gt;
gt; gt; =IF(L2gt;K2,L2-1,L2)
gt; gt; --
gt; gt; Gary's Student
gt; gt;
gt; gt;
gt; gt; quot;Valerianquot; wrote:
gt; gt;
gt; gt; gt; I am using a formula to determine time per unit produced and one of the
gt; gt; gt; pieces of data is based on the number of stations on the production line
gt; gt; gt; minus one (L2-1). What I need to do is have the condition set that if L2 is
gt; gt; gt; greater than K2 (quantity) use L2-1 if it is not greater than K2 then us L2.
gt; gt; gt; Can anyone help me?
gt; gt; gt;
gt; gt; gt; If there is anyone using formulas to produce production data in a
gt; gt; gt; manufacturing environment, any information you have would be most helpful.
gt; gt; gt;


or just

=M2/(K2 L2-(L2gt;K2))--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=526365