Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF, but Not to Exceed
Can I add an argument to an IF statement that will result in a calculation,
but not if it exceeds a certain amount? For example, can I have an IF statement display the result F5-F4, but if F5-F4 exceeds E5 then it will display E5? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF, but Not to Exceed
Try this:
=MIN(F5-F4,E5) -- Biff Microsoft Excel MVP "dnamertz" wrote in message ... Can I add an argument to an IF statement that will result in a calculation, but not if it exceeds a certain amount? For example, can I have an IF statement display the result F5-F4, but if F5-F4 exceeds E5 then it will display E5? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF, but Not to Exceed
On Sat, 24 Jan 2009 10:18:00 -0800, dnamertz
wrote: Can I add an argument to an IF statement that will result in a calculation, but not if it exceeds a certain amount? For example, can I have an IF statement display the result F5-F4, but if F5-F4 exceeds E5 then it will display E5? something like =max(e5,f5-f4) --ron |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF, but Not to Exceed
On Sat, 24 Jan 2009 13:34:27 -0500, Ron Rosenfeld
wrote: On Sat, 24 Jan 2009 10:18:00 -0800, dnamertz wrote: Can I add an argument to an IF statement that will result in a calculation, but not if it exceeds a certain amount? For example, can I have an IF statement display the result F5-F4, but if F5-F4 exceeds E5 then it will display E5? something like =max(e5,f5-f4) --ron Ooops -- that should have been =min(e5,f5-f4) --ron |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF, but Not to Exceed
The responses you got were correct for the example you gave, but the general
answer to your question is yes and a general IF solution would read =IF(Test,Calculation1,Calculation2) or with your sample: =IF(F5-F4E5,E5,F5-F4) -- If this helps, please click the Yes button Cheers, Shane Devenshire "dnamertz" wrote: Can I add an argument to an IF statement that will result in a calculation, but not if it exceeds a certain amount? For example, can I have an IF statement display the result F5-F4, but if F5-F4 exceeds E5 then it will display E5? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cannot Exceed | Excel Worksheet Functions | |||
Exceed Row Limit | Excel Worksheet Functions | |||
Exceed Row Limit | Excel Worksheet Functions | |||
Matching a value, which does not exceed Min or Max. | Excel Worksheet Functions | |||
Exceed Scale | Charts and Charting in Excel |