Simple Multiple If Statement Problem

[bfraser]

I am having difficulty doing a multiple IF statement formula in Excel. i keep doing something wrong. I have two values, one in A & one in B.
I need a multiple If statement that does the following.
If B is greater that A, then insert the value of A into cell C
If B is less than A, then insert the value of B inter cell C
If B is negative, then insert a value of Zero into cell C
I would really appreciate if someone could help me with my problem.

 

[AlphaFrog]

Try something like this...
=MAX(MIN(A1,B1),0)

 

[bfraser]

Thank you very much AlphaFrog. That worked great!!!

Thank you very much AlphaFrog. That worked great!!!