Previous Topic Next Topic

Excel formula A+B=C with the following except

Solved/Closed
Scott - Mar 2, 2011 at 06:06 PM
 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

Related:

2 responses

Answer 1 / 2
rich
Mar 2, 2011 at 07:03 PM
=IF(B1=0,(0),(IF(B1>A1,A1,A1+B1)))
0
Answer 2 / 2
Scott
Mar 3, 2011 at 11:28 AM
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!
0

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses
formulas for 1st and 2nd position in class
jack -
suff954 -

1 response