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

Riny_van_Eekelen

Platinum Contributor

Apr 23, 2020

rboze

If I'm not mistaken that could be:

=MIN(8,<ref>)

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.