Cell displays value unless sum of a range exceeds cell value.
I'm looking for a formula that will display a certain value in a cell, unless the sum of a range exceeds the value in that original cell. Example: I want B3 to display a value of 120 unless the sum of B6 through B10 is greater than 120. Then I want it to display the sum of that range.
I'm still kind of new to excel, so I hope that makes sense. I tried to Google it, but I can't find exactly what I'm looking for. Thanks!
May be this,
=MAX(120,SUM(B6:B10))
Regards,
Haseeb Avarakkan
__________________________________
"Feedback is the breakfast of champions"
In your example, where does the 120 come from?
Let's assume it comes from some other formula, like adding together two other cells such as A1+A2. And suppose the range you are talking about is C2:D6. Then your formula is:
Formula:
Please Login or Register to view this content.
Now replace "A1+A2" with whatever is giving you 120, and replace "C2:D6" with your actual range.
A more detailed description of your problem will get a more specific answer.
Looks like that works Haseeb. Thank you!
Haseeb A's formula is cleaner. If you are using the literal number 120, then that formula is your solution. If instead it comes from some other calculation, simply replace "120" with whatever the calculation is.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks