Need a cell to return a specific value greater than 250,000 from another group of cells

[samdaman91]

I need some help in developing a cell that returns any value greater than 250,000 from a group of cells on another sheet. For example let us say that I have the values of 500, 400,750, and 252,000 on another sheet. I want this cell to return the specific value of 252,000 not 250,000. I tried using the "IF" function but i can't really hone in on the answer. PLEASE HELP!!!

PS
=if('OOP Revenue'!B2:B14>250000,idk,0) That is what i have so far.

[duncandhu]

You could get the formula to return the biggest value over 250,000 using

Please Login or Register  to view this content.

The problem arises if there is more than one value that is > 250,000. Do you want to display more than one value in a cell?

Regards
Duncan

[ChemistB]

or what to do if there is no value > 250000

[duncandhu]

You would replace the idk part in the formula you have with the MAX part to achieve that. If there is no value then it will return 0.

Thanks
Duncan

[samdaman91]

Thank you very much first of all. It did work out however I only want the max value only if it is >250k. Max will return the largest value even if it is <250k. Also rarely but sometimes there are more than 2 or more values over 250k. So i was thinking sumif. If anybody can help I will greatly appreciate it.

@ChemistB if not, the cell will return 0.

[duncandhu]

My mistake, try:

Please Login or Register  to view this content.

Regards,
Duncan

[samdaman91]

Thanks to all. I have it. its =sumif(A:e,">250k",A:e)