| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Embedding an OR statement in an IF statement efficiently | Excel Discussion (Misc queries) | |||
| Can an If statement answer an If statement? | Excel Discussion (Misc queries) | |||
| appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
| If statement and Isblank statement | Excel Worksheet Functions | |||
| Help please, IF statement/SUMIF statement | Excel Worksheet Functions | |||
![Liz J[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
