Turn fraction around

PabloFer

New Member
Joined
Sep 16, 2020
Messages
12
Office Version
365
Platform
Windows
You did not look at the formula I posted carefully enough... I have the J4 and F4 reversed. I'll show you again...

=F4/J4

Try it to see (still set the cell format to Fraction).
got it thank you, I tried that one before but it doesn't work I need to show the 3/1
 

Some videos you may like

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying

Dave Patton

Well-known Member
Joined
Feb 15, 2002
Messages
4,155
Office Version
2010
Platform
Windows
N.B. based just on " The formula is a division =J4/F4 the result is 1/3 the format of cell L4 is in fraction and I need to present 3/1 "
I did not look at the images.

Consider the following:

T202008c.xlsm
FGHIJKL
3310.3333333
431 1/33/1
5
6FormattedFormatted
7as fractionCustom #/1
8
4c
Cell Formulas
RangeFormula
K3:K4K3=J3/F3
L3:L4L3=F3/J3
 

Subscribe on YouTube

Watch MrExcel Video

Forum statistics

Threads
1,105,857
Messages
5,507,756
Members
408,647
Latest member
Nicho la zido

This Week's Hot Topics

Top