ISSUE WITH COMBINED FORMULA (SOLVED)

Questions and answers about FreeOffice PlanMaker 2018 for Linux
Post Reply
User avatar
adpd777
Posts: 4
Joined: Thu Oct 22, 2020 9:38 am

ISSUE WITH COMBINED FORMULA (SOLVED)

Post by adpd777 » Thu Oct 22, 2020 10:34 am

Hello.

First at all, thanks for this software, it's kinda good and I can achieve most of the work that I need to do.
Well, after that little intro, I'm going to explain the issue that I'm dealing with.
I have some columns with boolean values, but at the column K4, as in the attachment 04, I get the result of "#VALUE!" error, and I'm pretty sure that Im doing the excercise correctly.

Check the screenshots from 01 to 04, you'll see what I mean.

Am I doing something wrong or is it a bug?

Thanks again.
Attachments
03.jpg
02.jpg
01.jpg
Last edited by adpd777 on Sat Nov 21, 2020 12:06 am, edited 2 times in total.

SuperTech
SoftMaker Team
SoftMaker Team
Posts: 1018
Joined: Wed Mar 11, 2020 5:31 pm

Re: ISSUE WITH COMBINED FORMULA

Post by SuperTech » Thu Oct 22, 2020 4:55 pm

Thanks for reporting this problem. Please share the associated file in which you are getting this problem so that we can do further investigation for resolution.

If you want to send it to us privately, please e-mail us at the forum[at]softmaker.de

Please also include the forum URL of this topic so that we can trace your e-mail.

Code: Select all

http://forum.softmaker.com/viewtopic.php?f=322&t=20511&p=68024#p68024

User avatar
adpd777
Posts: 4
Joined: Thu Oct 22, 2020 9:38 am

Re: ISSUE WITH COMBINED FORMULA

Post by adpd777 » Thu Oct 22, 2020 8:55 pm

Hello again.

Here is the file attached, where I'm having the #VALUE! error, these cells contains a combined formula where the value is being taken from another cells with a combined formula too, but it looks like these cells with the error, are taking the formula of the referred cells as a text and not the value contained in it...or maybe I'm doing something wrong.

Anyway, thanks for your fast answer.
Attachments
True_Table.xlsx
(10.6 KiB) Downloaded 9 times

SuperTech
SoftMaker Team
SoftMaker Team
Posts: 1018
Joined: Wed Mar 11, 2020 5:31 pm

Re: ISSUE WITH COMBINED FORMULA

Post by SuperTech » Thu Oct 29, 2020 2:53 pm

This is because in some places the correct format of numbers are not there in the argument of the function which is required. To resolve this problem just multiple all functions with 1 and your problem will be resolved.

e.g. change =DEC2BIN(AND(E4,B4)) to =DEC2BIN(AND(E4,B4))*1

User avatar
adpd777
Posts: 4
Joined: Thu Oct 22, 2020 9:38 am

Re: ISSUE WITH COMBINED FORMULA

Post by adpd777 » Sat Oct 31, 2020 7:47 am

Hello again.
Thank you very much!...your solution worked like a charm!
You can close this post now, problem solved.

Post Reply

Return to “FreeOffice PlanMaker 2018 for Linux”