| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
if formula needed
Hello, If A1 is greater than the sum of B1+B2, return the difference of A1
minus the sum of B1+B2 but not greater than the value of C3. If false return value of c3. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if formula needed
This should do the trick:
=IF(AND(A1(B1+B2),A1<C3),A1-(B1+B2),C3) -- Kevin Backmann "Theresa" wrote: Hello, If A1 is greater than the sum of B1+B2, return the difference of A1 minus the sum of B1+B2 but not greater than the value of C3. If false return value of c3. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if formula needed
=IF(A1(B1+B2),MIN(A1-(B1+B2),C3),C3)
Hope this helps. -- John C "Theresa" wrote: Hello, If A1 is greater than the sum of B1+B2, return the difference of A1 minus the sum of B1+B2 but not greater than the value of C3. If false return value of c3. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if formula needed
=IF(A1B1+B2,MIN(A1-(B1+B2),C3),C3)
-- Regards. Daniel "Theresa" a écrit dans le message de news: ... Hello, If A1 is greater than the sum of B1+B2, return the difference of A1 minus the sum of B1+B2 but not greater than the value of C3. If false return value of c3. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if formula needed
Hi Theresa
try =MIN(C3,A1-B1-B2) -- Regards Roger Govier "Theresa" wrote in message ... Hello, If A1 is greater than the sum of B1+B2, return the difference of A1 minus the sum of B1+B2 but not greater than the value of C3. If false return value of c3. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if formula needed
Roger, are you sure that your formula satisfies the last part of the
requirement: "If false return value of c3." ? -- David Biddulph "Roger Govier" <roger@technology4unospamdotcodotuk wrote in message ... Hi Theresa try =MIN(C3,A1-B1-B2) -- Regards Roger Govier "Theresa" wrote in message ... Hello, If A1 is greater than the sum of B1+B2, return the difference of A1 minus the sum of B1+B2 but not greater than the value of C3. If false return value of c3. |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if formula needed
Hi David
You're quite right. My bad. Didn't test with values less than B1+B2 -- Regards Roger Govier "David Biddulph" <groups [at] biddulph.org.uk wrote in message ... Roger, are you sure that your formula satisfies the last part of the requirement: "If false return value of c3." ? -- David Biddulph "Roger Govier" <roger@technology4unospamdotcodotuk wrote in message ... Hi Theresa try =MIN(C3,A1-B1-B2) -- Regards Roger Govier "Theresa" wrote in message ... Hello, If A1 is greater than the sum of B1+B2, return the difference of A1 minus the sum of B1+B2 but not greater than the value of C3. If false return value of c3. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If Then formula help needed | Excel Worksheet Functions | |||
| IF/AND/OR FORMULA HELP NEEDED | Excel Discussion (Misc queries) | |||
| Formula Set Up Needed | Charts and Charting in Excel | |||
| Formula Needed! | Excel Discussion (Misc queries) | |||
| Formula needed | Excel Worksheet Functions | |||
Linear Mode
