Forum Discussion

mdianah's avatar
mdianah
Copper Contributor
Nov 28, 2018

ignore blank cells in formula

I have an IF(OR) formula, where it sometimes will refer to blank fields. I need it to completely ignore the blank fields.

The formula: =IF(OR(B5<1;E5<1;K5<1);"sekundær(true)";"primær (false)")

If everything in the cells are over 1, i want it to write "priær". If it's a number less than 1 - "sekundær" - if K5 does not contain any number, I just want it to focus on the two other cells.

Any advice?

excel
Formulas and Functions

2 Replies

  • Detlef_Lewin's avatar
    Detlef_Lewin
    Silver Contributor
    Nov 28, 2018

    Hi

     

    Your description does not match your formula. And your description misses out on the case =1.

    Please provide a file with all possible combinations and the desired results.

     

    • mdianah's avatar
      mdianah
      Copper Contributor
      Nov 28, 2018
      Detlef_Lewin wrote:

      Hi

       

      Your description does not match your formula. And your description misses out on the case =1.

      Please provide a file with all possible combinations and the desired results.

       

      I've  just changed the larger than sign (<). If it's  eqaul to 1, then it's supposed to  be "primær" (false)

Resources