ignore blank cells in formula

Copper Contributor

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?

2 Replies

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.

 


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