IF Statement

[Liz J]

Could you please help me with putting in a formula?
I'm taking a sum of a row, cell FK339= sum(DK339:FJ339). If this sum
formula is not greater than or equal to 200,000, I want FK339 to equal
200,000.

How do I go about making that as an if statement?

Thank you for your help!

 

[Don Guillett]

Look in the help index for MIN

 

[Eduardo]

Hi,
=if(sum(DK339:FJ339)<200000,200000,sum(DK339:FJ339))

 

[Dave Peterson]

You have at least a couple of ways:

=if(sum(dk339:fj339)<200000,200000,sum(dk339:fj339))
or
=max(200000,sum(dk339:fj330))

 

[David Biddulph]

Or MAX?
--
David Biddulph

Look in the help index for MIN

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)

 

[Don Guillett]

Thanks.