https://bugs.documentfoundation.org/show_bug.cgi?id=112891
Eike Rathke <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
Resolution|--- |NOTABUG
--- Comment #11 from Eike Rathke <[email protected]> ---
(In reply to Daniel from comment #9)
> =100-(H29*100/K29) that gives me the percent number (without the percent
> sign). That result is 25,25
To only display that number with an appended percent sign you can use a number
format such as
0,00"%" or #,##" %" as indicated by Xavier.
Note the enquoted percent sign which makes it a string without
Otherwise change your calculations to actually calculate in percentages by
simply adding the % percent operator, so
=(100-(H29*100/K29))%
which divides the result by 100 and if the cell has the General format also
automatically applies the percent number format
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
