HI the

I am trying to create a function in a spreadsheet to run a test on two
columns which computes the result for the third column, I think I need
an additional test though because when a negative number is involved I
get the wrong result.

For example:

I am trying to test column A and B. Right now my formula is =IF(B<A,
B, A). So that if column B is less than column A my result is the
total in column B but if Column B is greater than column A my answer is
the total in column A. However, if the answer is going to be a negative
I want column C to say 0 not a negative number.

Column A Column B Column C
100 50 s/b 50
25 100 s/b 25
-100 10 s/b 0

At this point if my answer is negative using the above function, the
negative number is put in columm C. I want it to be 0. Can anyone
tell me how I can do this. I have tried using an "AND" function to do
this but then my answer always winds up being 0.

Your help is greatly appreciated.


--
Ally1977
------------------------------------------------------------------------
Ally1977's Profile: http://www.excelforum.com/member.php...o&userid=31483
View this thread: http://www.excelforum.com/showthread...hreadid=511605