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

Scott - Mar 2, 2011 at 06:06 PM - Latest reply:  Scott
- Mar 3, 2011 at 11:28 AM
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

See more 

2 replies

0
Thank you
=IF(B1=0,(0),(IF(B1>A1,A1,A1+B1)))
0
Thank you
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!