ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   IF formula (https://www.excelbanter.com/excel-discussion-misc-queries/219216-re-if-formula.html)

Stefi
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


All times are GMT +1. The time now is 02:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com