Formula Help

[picktr]

=SUM(I5-35)*0.8

I need the above formula, in cell K5,
to also include-

If the result is >= 22
True=22
False=SUM(I5-35)*0.8

Thanks

To

 

[Guest]

Excel has an IF function with this format:

IF( expression , true value , false value )

So in your example, it would be:

=IF( SUM(I5-35)*0.8 >= 22 , 22 , SUM(I5-35)*0.8 )

-Robert

 

[RagDyer]

Try this:

=MIN(0.8*(I5-35),22)
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


=SUM(I5-35)*0.8

I need the above formula, in cell K5,
to also include-

If the result is >= 22
True=22
False=SUM(I5-35)*0.8

Thanks

Tom

 

[Peo Sjoblom]

=IF(I5-35>=22,22,(I5-35)*0.8)

or

=(I5>=57)*22+(I5-35<22)*((I5-35)*0.8)

 

[Peo Sjoblom]

Why the SUM function?

--

Regards,

Peo Sjoblom

Excel has an IF function with this format:

IF( expression , true value , false value )

So in your example, it would be:

=IF( SUM(I5-35)*0.8 >= 22 , 22 , SUM(I5-35)*0.8 )

-Robert

 

[picktr]

Thanks!!!