Two functions in one formula.

  • Thread starter Thread starter MAX
  • Start date Start date
M

MAX

I need this formula, using Excel 2003.
Example:
A1 A2 A3
100 20 80 (Here I want that when A3 is < than A1,
answer becomes 100 0 140 in cell A2 and in the same
formula when A3 is > than A1,
answer in A2 becomes 0).
 
Back
Top