MacOS 10.11.6, Libre Office 5.1.4.2
Here is my original formula, its a discontinuous function over a range, requiring some if statements
=IF(B31<10^-6,“NA”,IF(B31<0.00002,0.0000010099503 / B31^0.985,IF(B31<10,0.0019102931 / B31^0.2811,IF(B31<1000,0.001,“NA”’))))
Note there are 4 ('s, there for 4 )'s at the end.
When I hit return, Calc changes the formula to:
=IF(B31<10^-6,“NA”,IF(B31<0.00002,0.0000010099503 / B31^0.985,IF(B31<10,0.0019102931 / B31^0.2811,IF(B31<1000,0.001,“NA”’)))))))))
Note all the )'s at the end. It then gives an err:508. What do I do?
I also note many say to use ; between items in an If statement, but when I do Calc changes them to , .
On this webpage I have selected English, but the reCAPTCHA keeps changing to Chinese?