IF(OR(ISNUMBER(SEARCH("Apple",N2)), ISNUMBER(SEARCH("Banana",N2)),ISNUMBER(SEARCH("Peach",N2)),ISNUMBER(SEARCH("Pear",N2))),"Fruit",IF(OR(ISNUMBER(SEARCH("Beef",N2)),ISNUMBER(SEARCH("Chicken",N2)), ISNUMBER(SEARCH("Pork",N2))....
Libreofficecalc is not filling down formula as expected. For example the above formula, the cell reference is N2 and when I use fill down, I expect the N2’s to all change to N3 and so forth but what it is doing is below. It has changed only some N2’s to N3 but keeping N2 in other parts of the formula. Can someone tell me why it is doing this and how to fix it.
IF(OR(ISNUMBER(SEARCH("Apple",N3)), ISNUMBER(SEARCH("Banana",N3)),ISNUMBER(SEARCH("Peach",N3)),ISNUMBER(SEARCH("Pear",N3))),"Fruit",IF(OR(ISNUMBER(SEARCH("Beef",N2)),ISNUMBER(SEARCH("Chicken",N2)), ISNUMBER(SEARCH("Pork",N2)).......
[erAck: edited to format code as code, see This is the guide - How to use the Ask site? - #6 by erAck]