Thread: IF Statement
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Eduardo Eduardo is offline
external usenet poster
 
Posts: 2,276
Default IF Statement

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

"Liz J" wrote:

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!