Nov 28 2018 08:41 AM - edited Nov 28 2018 10:58 AM
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?
Nov 28 2018 09:36 AM
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.
Nov 28 2018 11:02 AM
@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)