How do I key in fractions in formulae?

[Display Name]

How should I key in fractional forms in Excel formulae, ie on the scientific
calculator, there is the 'a b/c' key to use as the "stroke" in the fraction,
so is there an Excel equivalent of that key (ie a symbol) or is it keyed in a
different way?

 

[Sandy Mann]

3 1/2 can be entered in a formula as: 3 + 1/2 If you are then going to use
this in a calculation in the same formula like: 3 1/2 / 6 1/2 enclose the
additions in brackets:

=(3+1/2)/(6+1/2)

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Bernard Liengme]

You can type 3 1/2 in a cell and that is what you will see; Excel will store
3.5
For numbers less than 1, I recommend 0 1/6; the zero will not display - if
omitted Excel will think you want a date entry
The formula =3 1/2 + 4 1/4 gives 7.75; you can then format it with # ?/?
(easy way is to use Format Painter from cell the 3 1/2)
=MAX(3 1/2, 3 1/3) gives correct answer of 3.5 again you would need to
format to display fraction
If you want say sixteenths use # ?/16 as the format
best wishes

 

[ShaneDevenshire]

Hi,

I think what your looking for is 5 3/5 to enter in that display?

If so type 5 3/5 and hit enter. Leave a space between the 5 and the 3/5.
Excel will display it in that format but if you look at the formula bar you
will see what Excel really has in the cell.