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

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

5 Replies

deepkya
Copper Contributor
Apr 23, 2020
Try This-
If(ref >=8,8,ref)
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