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?

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?
>

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?
>