Excel formula A+B=C with the following except [Solved/Closed]

Report
-
 Scott -
Hello,
I really could use some help please. I am working on an 2010 excel spreadsheet. Would anyone know if there is a formula to do the following.
A+B=C with the following exceptions.
If B=0 than C=0
If B is > A then C=A.

Thank you very much for any help you can give me!!!
Scott

2 replies

=IF(B1=0,(0),(IF(B1>A1,A1,A1+B1)))
Thank you very much!! This made this task much easier for me. I wish I would have know to ask you guys for help a long time ago. This will save me a lot of time.
Thanks again!