IF formula
=MAX(0,MIN(2000,A1+B1))
Regards,
Stefi
Zul ezt *rta:
The sum of A1 & B1 if it is greater than 2000 I want to display 2000 in C1,
and if it between 1 and 1999 the actual should be displayed. If the figure is
in minus I want it to be displayed 0 in C1
|