Forum Discussion

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
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

rboze

Copper Contributor

Apr 23, 2020

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.

mtarler

Silver Contributor

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

rboze
Copper Contributor
Apr 23, 2020
mtarler Perfect. Thank you. Both work perfect. Very much appreciated.