Diffilculty with my "IF" statement

[mlglover]

I have a basic understanding of the “IF” statement and have successfully used it in the past. But I am having difficulty with my new formula. What I am trying to do is have C2 added to D2 and show the answer if it is less than 5760, but if it is equal to or greater than 5760 I want it to show 5760. This is what I have started with, =if(and(c2+d2,c2+d2>5760=true)"5760") I know the logical statement number one isn’t showing if it is a true or false statement I was hoping that it would fill in the calculation. Any advice will greatly be appreciated, and if you need any additional information please let me know.

 

[Jonmo1]

Try

=MIN(5760,C2+D2)