post #1 of 1
Thread Starter 
Okay to start off hopefully I'm creating this thread in the right location....

Anyways onto my issue, basically I am creating a ratio between three numbers... B/C/D... These numbers are often in the millions so I want them reduced as much as possible so I came up with the following equation....

=B5/GCD(B5,C5,D5)/D5&" : "&C5/GCD(B5,C5,D5)/D5&" : "&D5/GCD(B5,C5,D5)/D5

The reason I did it this way is because I wanted the output to come out as x : y : 1 and it works perfectly except for one issue.. It displays like 15 decimal places and now matter what I do I can't get it to remove the decimal places... So for example I am getting 5.321xxxxxx : 2.429xxxxx : 1, I want to get 5.3 : 2.4 : 1. How Can I get my equation to do this?

Additionally I already tried formatting the cell and manually moving over the decimal places with no success, I've been trying to also playing with the =ROUND and =TRUNC functions. Any help is appreciated.
Chibi
(12 items)
 
Arcturus
(8 items)
 
 
CPUMotherboardGraphicsGraphics
i7-3770s Gigabyte G1. Sniper M3 AMD 7850 AMD 7850 
RAMHard DriveOptical DriveOptical Drive
G.Skill Sniper Series low voltage OCZ Vertex 4 Max IOPS LG DVD Burner dual-layer LG Bluray Burner dual-layer 
CoolingOSPowerCase
Custom liquid Windows 7 Ultimate 64 bit Corsair AX650 Fractal Design Arc Mini 
CPUCPUMotherboardRAM
AMD Opteron 4386 AMD Opteron 4386 SUPERMICRO MBD-H8DCL-6F-O Crucial 8GB 240-Pin DDR3 1600 SDRAM ECC Registe... 
Hard DriveOSCaseOther
Western Digital RE WD1001FYYG 1TB 7200RPM 32MB ... Windows Server 2008 R2 SUPERMICRO CSE-825TQ-R700LPB Black Adaptec RAID 2274200-R 7805 
  hide details  
Reply
Chibi
(12 items)
 
Arcturus
(8 items)
 
 
CPUMotherboardGraphicsGraphics
i7-3770s Gigabyte G1. Sniper M3 AMD 7850 AMD 7850 
RAMHard DriveOptical DriveOptical Drive
G.Skill Sniper Series low voltage OCZ Vertex 4 Max IOPS LG DVD Burner dual-layer LG Bluray Burner dual-layer 
CoolingOSPowerCase
Custom liquid Windows 7 Ultimate 64 bit Corsair AX650 Fractal Design Arc Mini 
CPUCPUMotherboardRAM
AMD Opteron 4386 AMD Opteron 4386 SUPERMICRO MBD-H8DCL-6F-O Crucial 8GB 240-Pin DDR3 1600 SDRAM ECC Registe... 
Hard DriveOSCaseOther
Western Digital RE WD1001FYYG 1TB 7200RPM 32MB ... Windows Server 2008 R2 SUPERMICRO CSE-825TQ-R700LPB Black Adaptec RAID 2274200-R 7805 
  hide details  
Reply