If and Or

E

Excel neophyte

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

Excel neophyte

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!
 
T

Toppers

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

Excel neophyte

dollar amounts

Toppers said:
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?
Click to expand...
 
Top