IF formula

Z

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
 
P

Pecoflyer

Zul;214852 said:
The sum of A1 & B1 if it is greater than 2000 I want to display 2000 i
C1,
and if it between 1 and 1999 the actual should be displayed. If th
figure is
in minus I want it to be displayed 0 in C1
Click to expand...

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


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

--
Pecoflye

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

*Adding your XL version* to your post helps finding solution faste
 
D

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.
 
Z

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
 
Top