 |
 | 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/Or Clarified
If A1 is greater than A2, the Replacement Cost or Total Cost to Re-Build is the minimum amount required. Enter Required amount in A5. If A2 is greater than A1, compare A3 to A1. If A3 is greater than A1, the amount in A3 is the minimum amount required. If A1 is greater than A3, then A1 is the minimum amount required. Enter minimum amount required in A5. Note: A3 is always 80% of A2. Need formula for A5 that satisfies all criteria. Is that possible? What you're looking to do sounds possible but it's not clear what replacement cost or total cost to re-build is, and what their cell references would be. Essentially you're looking for a formula that looks something like: IF(A>B,C,IF(B>D,if(D>A...etc.) > If A1 is greater than A2, the Replacement Cost or Total Cost to > Re-Build is the minimum amount required. Enter Required amount in A5. [quoted text clipped - 6 lines] > > Need formula for A5 that satisfies all criteria. Is that possible? try =min(A2,max(A1,A3)) (if A2 is the amount you want when A1 is greater A2.) > If A1 is greater than A2, the Replacement Cost or Total Cost to > Re-Build is the minimum amount required. Enter Required amount in A5. [quoted text clipped - 6 lines] > > Need formula for A5 that satisfies all criteria. Is that possible? |
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.