ISSUE WITH COMBINED FORMULA (SOLVED)

[adpd777]

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.

[SuperTech]

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

[adpd777]

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.

[SuperTech]

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

[adpd777]

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