Den lör 27 apr. 2019 kl 13:29 skrev Johnny Rosenberg :
>
>
> Den fre 26 apr. 2019 kl 23:09 skrev Luuk :
>
>> YES, LCM() that's the function i was looking for...
>>
>> I did not know it that function exists, probably because it's name in my
>> Dutch version of EXCEL is KGV(). :-[
>>
>
> It's na
Den fre 26 apr. 2019 kl 23:09 skrev Luuk :
> YES, LCM() that's the function i was looking for...
>
> I did not know it that function exists, probably because it's name in my
> Dutch version of EXCEL is KGV(). :-[
>
It's named ”MGM()” in my Swedish version (Minsta Gemensamma Multipel).
Do you
YES, LCM() that's the function i was looking for...
I did not know it that function exists, probably because it's name in my
Dutch version of EXCEL is KGV(). :-[
(see:
https://www.excel-function-translation.com/index.php?page=english-dutch.html
)
On 26-4-2019 22:54, Johnny Rosenberg w
reply inserted in your post.
On 26-4-2019 22:42, Johnny Rosenberg wrote:
Den fre 26 apr. 2019 kl 20:37 skrev Luuk :
Let me rephrase the question ;)
In the 'example' line we see:
56 30228/151
The actual cell contents are:
56 302 0,18543046357615894039735099337748
Is it possibl
Den fre 26 apr. 2019 kl 22:42 skrev Johnny Rosenberg :
> Den fre 26 apr. 2019 kl 20:37 skrev Luuk :
>
>> Let me rephrase the question ;)
>>
>> In the 'example' line we see:
>>
>> 56 30228/151
>>
>> The actual cell contents are:
>>
>> 56 302 0,18543046357615894039735099337748
>>
>> Is
Den fre 26 apr. 2019 kl 20:37 skrev Luuk :
> Let me rephrase the question ;)
>
> In the 'example' line we see:
>
> 56 30228/151
>
> The actual cell contents are:
>
> 56 302 0,18543046357615894039735099337748
>
> Is it possible to get the values '28' and '151' as show by the
> fraction
Let me rephrase the question ;)
In the 'example' line we see:
56 302 28/151
The actual cell contents are:
56 302 0,18543046357615894039735099337748
Is it possible to get the values '28' and '151' as show by the
fraction-formatter?
On 26-4-2019 19:01, Luuk wrote:
Is there an
Calc can format cells as a fraction.
For instance in an empty cell input "=pi()" without the quotes. The cell
will display 3.141592654.
Then format the cell as FORMAT -> FRACTION -> FORMAT CODE -> and enter
???/??? which will change the display to 355/113. Is this what you need?
On 4/25/19
Is there an option to convert a cell with format 'Fraction' to text?
example:
a b 'a/b
52 297 52/297
56 302 28/151
66 311 66/311
in this third line, i want to get '28' and '151'
i tried TEXT(C2;""), and FIND("/";C2;1),
On 26-4-2019 00:45, Remy Gaut
Yes, Calc.
It works well enough using format code "# ??/200".
I guess I can use /200 for all of them but I was hoping for a formula
that would pick the lowest denominator.
Thanks.
On 2019-04-25 6:45 p.m., Remy Gauthier wrote:
Hi,
I am assuming you are using Calc. There is no formula to do
Hi,
I am assuming you are using Calc. There is no formula to do this: it is
a cell formatting accessible via Format -> Cells... -> Numbers Tab,
then go to the "Fraction" category. There you can select the # ???/???
format which will do what you are looking for.
I hope this helps.
R??my.
Le jeudi
I need a formula that takes as input a percent and outputs a fraction
that only has whole numbers.
Eg.
1% -> "1/100"
0.5% -> "1/200"
1.5% -> "3/200"
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscri
12 matches
Mail list logo
