LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 6
Default If/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?

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 01:41 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"