ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I write the fraction "1/n" ? (https://www.excelbanter.com/excel-discussion-misc-queries/15252-how-do-i-write-fraction-%221-n%22.html)

Elena

How do I write the fraction "1/n" ?
 
How can I write "1/n" ??

Michael

Hi Elena
Select
Format/Cells/Number and select Fraction.
Then simply type in 1 / n

HTH
Michael

"Elena" wrote:

How can I write "1/n" ??


Bob Tarburton


Just using my imagination here.
Are asking how to represent a vaule as "1/n"?

If you have a value in A1
="1/"&1/A1
If A1=4, this returns 1/0.25
or if if A1=0.25, this is 1/4

If this is what you're looking for you might to use a round on A1
="1/"&1/round(A1,<#ofdigits)

I'd be curious to hear if there is a way customer format this.



On Sun, 27 Feb 2005 13:59:01 -0800, "Elena"
wrote:

How can I write "1/n" ??




All times are GMT +1. The time now is 02:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com