# If/Or Clarified

1. ## 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?  Register To Reply

2. ## RE: If/Or Clarified

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.)

"Excel neophyte" wrote:

> 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?
>  Register To Reply

3. ## RE: If/Or Clarified

try
=min(A2,max(A1,A3))
(if A2 is the amount you want when A1 is greater A2.)

"Excel neophyte" wrote:

> 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?
>  Register To Reply

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1