Ask Your Question

Logical results (boolean) instead of numeric ones in calc

asked 2015-08-30 16:59:00 +0200

pcav gravatar image

Hi all. in calc, I'm getting logical results (true/false) instead of numeric results for simple formulas like =2/4 it worked fine until recently, possibly until the last upgrade (I'm on now) Thanks for any hint

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2015-09-01 01:20:14 +0200

m.a.riosv gravatar image

Maybe it's inherited from cell above or a referenced cell, or using a formula that gives a boolean result, as e.g. IF(comparison;forTrue)

Use Menu/Format/Clear direct format [Ctrl+M] to restore cell format.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2015-08-30 16:59:00 +0200

Seen: 691 times

Last updated: Sep 01 '15