Created attachment 125488 [details]
On pc Debian x86-64 with LO Debian package 220.127.116.11, I could reproduce this but I don't reproduce with LO master sources updated today.
Can you? I couldn't, and see 150 in 18.104.22.168 as well.
The formula translates to this in English, right?: =IF(AND(B1 > A1; B1 < A2); B1; "")
Could you or h7rojas upload it as a sample document?
An unrelated, interesting observation:
Is it normal that copy-pasting between different Calc instances (eg. multiple different versions running), the formula is evaluated, and pasted as 150?
Only when it's the same Calc (different or same files, doesn't matter) the formula transferred as a formula.
Created attachment 125516 [details]
Got an e-mail from h7rojas with some details, thanks. My conclusion is a bit different, though (the information I got is that it occurs in 64-bit, but not in 32-bit).
Before I spoil the details, see attachment, and in particular formula/values C1 and C2.
C1 is formatted as Boolean value, and 150 is TRUE if it's displayed as boolean. However, I didn't format it as such. What happens is that if you first input a boolean formula in the field, it's displayed as Boolean value, if you later change it to a numerical formula, the display format doesn't change, and the result is displayed as boolean.
I'm leaning towards considering this a bug, but there are many different cases here with different display formats, and automatically adjusting the display format might not work in all cases.
Reopened bug 75650. Closing this as duplicate.
*** This bug has been marked as a duplicate of bug 75650 ***