Forum Discussion

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

excel

Formulas and Functions

Detlef_Lewin

Silver Contributor

Nov 28, 2018

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

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)