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

Zul;214852 Wrote:
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

Hi,
try
Code:
--------------------
=if(a1+b1=2000,2000,if(a1+b10,a1+b1,0))
--------------------


I took the liberty of inserting the condition when the sum equal 2000


--
Pecoflyer

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows file
upload -faster and better answers

*Adding your XL version* to your post helps finding solution faster
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=58993

Put this in C1:

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

Hope this helps.

Pete

On Feb 5, 10:08*am, Zul wrote:
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

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

"Zul" wrote in message
...
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

You are welcome! Thanks for the feedback!
Stefi

€žZul€� ezt Ã*rta:

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

"Stefi" wrote:

=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

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

"Stefi" wrote:

=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