sumifs

[rboze]

I am trying to set a cell to do one of two things based on the input of another.  I either want the cell to equal "8" if the cell to the left is equal to or greater than "8" or equal the value of the cell to the left if the cells value is less than 8.  I have not used these functions in quite some time and seem to have lost my edge.   Any assistance would be greatly appreciated.

[#2]

@rboze 

If I'm not mistaken that could be:

=MIN(8,<ref>)

[#3]

@Riny_van_Eekelen I thought of that one and that would be perfect except for one thing and I forgot to mention it earlier.  If the <ref> cell is left blank it will create a value of 8.  If I were to input a "zero" in the <ref> cell it would be great.  And if that is what I have to do I will make it work.

[#4 · Accepted solution]

@rboze  maybe try =if(isblank(<ref>),0,min(<ref>,8))

better yet maybe =if(isnumber(<ref>),min(<ref>,8),0)

that way if it is a space or other text it will still force it to be 0

[#5]

@mtarler Perfect.  Thank you.  Both work perfect.  Very much appreciated.

[#6]

Try This-
If(ref >=8,8,ref)