Forum Discussion

rboze's avatar
rboze
Copper Contributor
Apr 23, 2020
Solved

sumifs

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...
excel
  • mtarler's avatar
    mtarler
    Apr 23, 2020

    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

deepkya's avatar
deepkya
Copper Contributor
Apr 23, 2020
Try This-
If(ref >=8,8,ref)

Resources