Ask Your Question
0

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: 4.2.8.2, 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

Comments

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

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

=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”,“”)))))))

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
0

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

Stats

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

Seen: 574 times

Last updated: Sep 22 '16