https://bugs.documentfoundation.org/show_bug.cgi?id=93851
Robinson Tryon (qubit) <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |RESOLVED CC| |[email protected] Resolution|--- |NOTABUG --- Comment #1 from Robinson Tryon (qubit) <[email protected]> --- (In reply to Jonathan Camilleri from comment #0) > Created attachment 118327 [details] > spreadsheet (ods) > > I cannot understand why C2 results in reading #VALUE in the attached. I am > unable to understand whether there is anything wrong with the formula itself > just by reading the value of the cell. Formula in C2 is "=IF(B2<0,-1,B1*$D$2)". Value in B1 is the string "Financial score", which cannot be used with the multiplication operator (*). Status -> RESOLVED NOTABUG -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
