Ask Your Question

Calc isn't accepting new nested "IF" functions; previously worked fine. How to fix? [closed]

asked 2016-09-21 12:31:10 +0200

Havaneiss Dei gravatar image

LibreOffice Version:, Build ID: 420m0(Build:2)

Computer is laptop (iBUYPOWER CZ-17; motherboard is proprietary, but similar to MSI-1762) with the following specs: CPU: Intel Core i7-3630QM @ 2.40 GHz RAM: (4x) GSKILL DDR3-1333 MHz 4GB SO-DIMM (16.0 GB installed; 15.9 GB usable) SSD: Mushkin Enhanced Reactor 1TB

OS: Linux Mint Rebecca Cinnamon

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by pierre-yves samyn
close date 2016-09-22 14:51:25.245034


And an example is ...? Beside that 4.2 is rather old.

erAck gravatar imageerAck ( 2016-09-21 13:18:50 +0200 )edit


Havaneiss Dei gravatar imageHavaneiss Dei ( 2016-09-21 15:03:51 +0200 )edit

The specs may not be relevant. But: In what way did Calc "not accept" the formula? Did you copy/paste the formula from some kind of text editor? If you look at the "formula" you posted above you find "typographical quotes" e.g. Not suitable for formulae! Use the tool for inserting code here. Try =IF(AND(B$3<>"";$A4>0;$A4<=B$3);"POS";(IF(AND($A4=0;B$3<>"";B$3>=0);"Q1Z";IF(AND($A4<0;B$3<>"";B$3>=0);"-N-";IF(AND($A4<0;B$3<>"";B$3<0);"NEG";""))))) copied from my comment. It might work.

Lupp gravatar imageLupp ( 2016-09-21 19:52:40 +0200 )edit

Can't believe I missed that! I did the setup in Writer, then C&P. DOH!

Havaneiss Dei gravatar imageHavaneiss Dei ( 2016-09-22 14:16:33 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2016-09-22 14:18:09 +0200

Havaneiss Dei gravatar image

updated 2016-09-22 14:49:03 +0200

SOLVED. Refer to comment by Lupp.

Thanks to the whole community of helpful folks; special thanks to Lupp for the helpful answer.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2016-09-21 12:31:10 +0200

Seen: 625 times

Last updated: Sep 22 '16