 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / August 2006If and Or
Please don't laugh, but I am having difficulties coming up with a formula that satisfies all criteria. This is the situation for a single cell, Line 5. If Line 1 is greater than Line 2, then Line 2 is the minimum amount required. Enter that amount on Line 5. If Line 2 is greater than Line 1, compare Line 3 to Line 1. If Line 3 is greater than Line 1, the amount on Line 3 is the minimum dollar amount required. If Line 1 is greater than Line 3, then the Amount on line 1 is the minimum amount required. Enter that amount on Line 5. in A5: =IF(A1>A2,A2,IF(A3>A1,A3,A1)) but what happens if A1=A2 orA3=A1? HTH > Please don't laugh, but I am having difficulties coming up with a formula > that satisfies all criteria. This is the situation for a single cell, Line 5. [quoted text clipped - 6 lines] > required. If Line 1 is greater than Line 3, then the Amount on line 1 is > the minimum amount required. Enter that amount on Line 5. What you offered produced no value at all. As to the other question if A1=A2, that is the value that should be in A5. The rest is moot. If A1=A3, same thing. Both questions could not happen at the same time, as A3 is always 80% of A2. Care to try again on this one? Thanks for your help! > in A5: > [quoted text clipped - 14 lines] > > required. If Line 1 is greater than Line 3, then the Amount on line 1 is > > the minimum amount required. Enter that amount on Line 5. Well... it worked when I tested it and it will always poduce a value, even if zero! What values do you have in A1,A2,A3? > What you offered produced no value at all. As to the other question if > A1=A2, that is the value that should be in A5. The rest is moot. If A1=A3, [quoted text clipped - 21 lines] > > > required. If Line 1 is greater than Line 3, then the Amount on line 1 is > > > the minimum amount required. Enter that amount on Line 5. dollar amounts > Well... it worked when I tested it and it will always poduce a value, even if > zero! [quoted text clipped - 26 lines] > > > > required. If Line 1 is greater than Line 3, then the Amount on line 1 is > > > > the minimum amount required. Enter that amount on Line 5. Toppers,... Got it! Thanks so much for your help. > dollar amounts > [quoted text clipped - 28 lines] > > > > > required. If Line 1 is greater than Line 3, then the Amount on line 1 is > > > > > the minimum amount required. Enter that amount on Line 5. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.