IF Statement

L

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!
 
D

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))
 
Top