IF formula

[Zul]

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

 

[Pete_UK]

Put this in C1:

=MAX(0,MIN(2000,A1+B1))

Hope this helps.

Pete

 

[David Biddulph]

=MAX(0,MIN(2000,A1+B1))
You didn't define what you wanted if A1+B1 is between 1999 and 2000, but I
guessed.

 

[Stefi]

You are welcome! Thanks for the feedback!
Stefi

„Zul†ezt írta:

 

[Zul]

Thanks for your quick reply. I had made a mistake in my posting. But i
figured it out from your formula.

Thanks a lot!!!!

Sum of A1-B1