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

Question

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 

Configuration: Windows XP / Firefox 3.6.14

rich · Answer

=IF(B1=0,(0),(IF(B1>A1,A1,A1+B1)))

Scott · Answer

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!

Excel formula A+B=C with the following except

2 responses

Similar discussions

Subscribe To Our Newsletter!