IF Statement
 

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!

IF Statement
 

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!

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!

IF Statement
 

You have at least a couple of ways:

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



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!

--

Dave Peterson

IF Statement
 

Or MAX?
--
David Biddulph

"Don Guillett" wrote in message
...
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!

IF Statement
 

Thanks.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
Or MAX?
--
David Biddulph

"Don Guillett" wrote in message
...
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!