| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
