Look in the help index for MIN

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Liz J" wrote in message
...
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!