Formula Help

P

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
 
G

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
 
R

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
 
P

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
Click to expand...
 
Top